Advanced Pivot Table Tricks #7 - Top 10 Filters

#top10Filter #ValueFilterPivotTables #HowtoTop10Pivot

By default Pivot Tables will show all of your data. What if you want to limit the information to just top 10 records. For example, you want to see which of the sales persons are top 10 in a given region? You can use value filters to easily set up such conditions. 

For example workbook and resources visit:

[jyotisharma]

Thankyou
meaningful, useful.. content explained in short time

[yahyamaniar]

Do you have any video on Inventory with expiry date data

[denisjcollins]

Hello Chandoo → My job requires me to "filter" data using Top 10 and Bottom 10: As I have not found a way to create one pivot table showing this, I create two pivot tables.
There has to be a way :)
Thank you in advance for your response.

[KamranMumtazAhmed]

Since there is no sheet where I can add more data, what should I do in this case?

[mbailey]

What if I wanted to view the raw data for only the top ten? When I double click the total I get the entire list again not just the top ten