You can easily Filter your Pivot Table to show your Top X customers.  There are lots of different Value Filters to choose from and one of my favorites is the Top 10 Filter.


Here is our pivot table:


STEP 1: Go to Row Labels > Value Filters > Top 10


STEP 2: Set it to the Top 5 Items. Click OK.

Your pivot table is now filtered!


Filter Top 5 Values

Helpful Resource:



If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Excel Filter by Selection When you have an array of data in Excel you can quickly select an item and press the AutoFilter button which will filter that selection in your data. You can then go over to another column within your data and select another item, apply the same steps above and further filter ...
Show Report Filter Pages in a Pivot Table When you are using an Excel Pivot Table you can show the items within the Report Filter on separate sheets inside your workbook. Say that you have created an awesome Pivot Table which shows total sales and number of transactions per region. You can drop in your Customer fie...
50 Things You Can Do With Excel Pivot Tables Pivot Tables in Excel are one of the most powerful features within Microsoft Excel.   A Pivot Table allows you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, "pivot"/change the report layout with the ease of dr...
Fix Column Width in a Pivot Table Each time you Refresh a Pivot Table you will most likely get annoyed at the fact that the column widths that you worked so hard to align - will return back to normal 🙁 Do not fear, Pivot Table Options is here! All you need to do is Right Click in the Pivot Table and choose...