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.


data table filter2. Now select the head you want to 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