Excel Super Dynamic Pivot Table - Top N - Middle N - Bottom N Slicer

Another video you might find useful where I show you a method to create a Pivot Table and a
Pivot Chart where you can select any "N" number of Slicer Ranking Items for a State Sales Table.

Also there are separate Dynamic Grand totals for the Slicer Ranking Selection and
Remainder Unselected Slicer Rankings.

You could use this method in your Dashboards and Reports to make it more interactive dynamically for your customers.

Enjoy!