Pivot Table: Top 10

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
 
A

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Problem - Show values as % of Grand total 0
PIvot Table top Values 1
Doughnut Chart linked with the slicer in the pivot table 0
Total in Pivot Table 0
PivotTabel shows top 10 and others 3
Pivot Tables - Top 10 hide negatives values 0
top ten filter 2

Top