Home Excel Tips and Tricks Filtering top 10 pivot table values

Filtering top 10 pivot table values

Filtering Top 10 Pivot Table Values

This time you will teach yourself how to filter top 10 values in your pivot table. Excel lets you do that to help you analysis data.

1. Open the sheet where you have your pivot table created.

2. Now select the head you want to filter. select the head to filter

3. Now, go to value filter and select top 10. A dialog will appear. (Set the criteria the way you like).

show top 10 items

4. Finally, click ok. Your pivot table is filtered.

pivot table filtered

You can download the Template here – Download

Further reading: 
Basic concepts 
Getting started with Excel
Cell References