topic Re: Displaying the top 10 customers in a pivot table by groups in Dashboards & Analytics Discussions

Displaying the top 10 customers in a pivot table by groups

dweaver — Thu, 15 May 2025 20:30:11 GMT

I am trying to create a pivot table that looks at 2 different sizes of our products and displays the top 10 in each category by the total sales. I was able to sort the sales dollars, but I am not sure how to limit the display. I did use the gear and only displayed 10 rows, but that is not showing the second grouping. Anyone have any guidance?

Re: Displaying the top 10 customers in a pivot table by groups

seifelewa — Sun, 18 May 2025 12:10:53 GMT

I think you could make the limit 20 rows so it shows the top 10 in each category , not sure if that's what you want

Re: Displaying the top 10 customers in a pivot table by groups

dylanwan — Tue, 20 May 2025 13:43:11 GMT

I have not tried it yet, but I feel that this is possible by using the Result Set feature. The aggregation by categories will be done within the result set using an aggregate table. We can give another RANK column in the result and use it in the insight as a filter.