How to group items not in Top 10?

[rlansing]

Hello,

I have a dataset that shows markets and weekly sales data for individual items, and I am trying to sum and rank the top 10 brands for a specific category. So I have a Rank measure that accurately calculates the rank for each brand. Now I am trying to create a table (or two stacked) that shows the specific $ and unit numbers for each of the top 10 brands, and then an "All Other" category at the bottom that sums all of the Brands that are greater than top 10. Any recommendations?

Thank you!

Bobby

[info_alchemist]

where you able to do this?

[info_alchemist]

where you able to do this?

[nikil · Accepted solution]

You will have to create measures that sums the $ for brands that are not in the Top 10 and use it in the visual