Pivot Table: Top 10

  • Thread starter Thread starter Vadim Rapp
  • Start date Start date
V

Vadim Rapp

Hello,

the sales pivot table shows the sales for 10 years.

However, the user is only interested in the last 3 years; so she clicks on
the dimension and unchecks other years.

Then she wants to see top 10 customers by sales.

Excel is showing top 10, but counting all 10 years.

Is there a way to show top 10 in the selected years only?


thanks,

Vadim Rapp
 
Move the years field into the upper page area of the pivot table
report.

When you select the year, if you've setup the pivot correct, it should
only show you the top 10 for the year selected.
 
Back
Top