Pivot Table: Top 10

[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

 

[Adam]

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.