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+