Home MS Excel TutorialExcelTips and Tricks Filtering top 10 pivot table values

Filtering top 10 pivot table values

by Easy Excel Tutorials

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 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

You may also like