4 Replies Latest reply on Mar 6, 2016 5:50 PM by Fei Sun

    How to concatenate top N sales subcategory into one string for better display?

    Fei Sun

      Hi,

       

      I am working on this problem, display top 5 sales subcategory per customer.

       

      I have one achievable way is to use the combined field and found top 5 sales using filter. But the issue is with the display, we need to keep the height of each of the segments (in this case customer name) the same height to maintain the format of the dashboard.

       

      I thought we could concatenate the top 5 best selling sub-categories for each customer name. In other words, I would like the visual to be similar with the visual effect described in the below-link.

      Re: Concatenating data from child rows

       

      Appreciate any feedback or guidance!