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.

DOWNLOAD EXCEL WORKBOOK

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:

728x90

 

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

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

Insert Grand Totals to a Pivot Table When you insert an Excel Pivot Table and drop a field in the Row/Column Labels you will automatically get a Grand Total. How about if you want to remove this Grand Total or show it only for a row or column? Well you have that flexibility and this is how... DOWNLOAD EXCEL...
Pivot Charts Pivot Charts in Excel are an extension of a Pivot Table and they show its values in a graphical representation.  So when you filter a Pivot Table, the Pivot Chart updates accordingly. To insert a Pivot Chart you need to click in your Pivot Table, go to the PivotTable Tools tab...
Free Pivot Table Webinar Hey there, I have been having a huge response to this highly acclaimed Pivot Table webinar and will continue to give these lessons in to the new year!  If a date is not suitable for you, you can always come back to the Registration link below on a future date.  Happy Pivot...
Running Total In % with an Excel Pivot Table A Running Total In is the accumulation of values over a certain period, like days, month or years.  It is sometimes referred to as the Year to Date analysis. A Running Total In takes one period's values, then adds a second period, then a third period...and so on, to give the a...