Displaying the top 10 customers in a pivot table by groups

[dweaver]

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? 

[seifelewa]

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

[dylanwan]

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.