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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Group Dates with a Pivot Table Grouping Dates is very easy with a Pivot Table.  All you have to do is Right Click on your Date values (which are either in the Row or Column Labels of your Pivot Table), then choose the Group option.  From the dialogue box you can choose to Group by Days, Months, Quarters or Yea...
Pivot Table Calculated Field Pivot Table Calculated Fields allow you to do mathematical calculations with your Field List.  You can use any of the Excel mathematical equations, like /*+-%.The only limitation is that you cannot reference any cells.  Pivot Table Calculated Fields can be used to calculate p...
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...
Conditionally Format a Pivot Table With Data Bars Data Bars are a new Conditional Formatting feature in Excel 2010 and they add a colored bar to your values.The length of the data bar represents the value in the cell.  A longer bar represents a higher value.You have a Gradient Fill or a Solid Fill to choose from as well ...