Hi Edward, how about this? I created a custom calculation that's just -SUM([Count]) and then forced it to be discrete so I could put it before the other dimensions. This basically forces the cells to sort in descending order by Count.

To do this, we'll need a LOD calculation to sum up the counts first:

{FIXED [Flavor] : SUM([Count])}

Then we make that a dimension, put that as the first dimension in the sheet, and move the other sort farther back so we don't get repeated rows.

If this is the correct solution, please mark it as correct. Thanks!

There's no way to hide them from the rows shelf, but as you can see, they don't show up in the view itself. If you don't want them to show up anywhere on the screen, you can put the sheet into a dashboard.

Right-click the pills and uncheck "Show Header".