Unfortunately, I'm not able to open your example, but you can try something like this:
Create a calculation to Rank your states field by the sum of sales (or which ever measure):
Place the pill on your columns shelf, then convert it to discrete.
Next, create a calculated field to filter your Rank pill to the top 5:
if [Sort by Rank]<6 then 1 else 0 end
Place this pill on the filters shelf, then filter to 1.
See the example below/
Hope this helps.
Just checking in to see if this answer was helpful.
Thanks. It was a little helpful, and it gave me an idea to switch the window_sum calculation to a LOD calculation, which I can sort on and use it in a rank to filter. Still not totally there, but getting close!