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 filter

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