Hi all! Trying to build a worksheet for top 100 customer revenue YTD. I have the customer name as a group and the measures as columns. Any idea on how to get it to sort descending on revenue instead only at the group?
Hi all! Trying to build a worksheet for top 100 customer revenue YTD. I have the customer name as a group and the measures as columns. Any idea on how to get it to sort descending on revenue instead only at the group?
Hi John,
If you right click over the Customer Name field in the Groups section and select Advanced Options, you can then specify the show first value, in this case 100 and then specify which column the group should be sorted by, specifying Desc as the order:
SEI will then show display the top 100 customers as individual lines. The remaining customers that fall out of the 'first' range will be grouped into an 'Others' total.
Hi John,
If you right click over the Customer Name field in the Groups section and select Advanced Options, you can then specify the show first value, in this case 100 and then specify which column the group should be sorted by, specifying Desc as the order:
SEI will then show display the top 100 customers as individual lines. The remaining customers that fall out of the 'first' range will be grouped into an 'Others' total.
Cool Nick! Thanks much!
*Community Hub is the new name for Sage City