Filters field is used to filter the data with single or multiple criteria. for example if we need to filter the supervisor wise data by “Product – 3“, we can click on filter arrow available in range “B1“. Select Product – 3 in the list.
Note: To select the multiple items in the list, check the “Select Multiple Items” below the drop down list.
![Filter in Pivot table](https://www.pk-anexcelexpert.com/wp-content/uploads/PivotTables/Pivot-table-7.jpg)
After using the filter by “Product – 3″, pivot table will look like below image-
![Pivot table after filter by "Product - 3"](https://www.pk-anexcelexpert.com/wp-content/uploads/PivotTables/Pivot-table-8.jpg)
Top/Bottom Filter
Top N or Bottom N items can be filtered in the pivot table.
Let’s say we have employee wise pivot table and we have to filter Top 5 employees by Revenue.
![Employee Wise Pivot Table](https://www.pk-anexcelexpert.com/wp-content/uploads/PivotTables/Pivot-Table-8.1.jpg)
Click on Row Labels drop down arrow >> Value filters >> click on Top 10…
![Top 10 option](https://www.pk-anexcelexpert.com/wp-content/uploads/PivotTables/Pivot-Table-8.2.jpg)
Below given window will be opened. Put 5 in place of 10 and select the Sum of Revenue.
![Top 10 Filter window](https://www.pk-anexcelexpert.com/wp-content/uploads/PivotTables/Pivot-Table-8.3.jpg)
Top 5 employees will be filtered by Revenue.
![Top 5 employees by revenue](https://www.pk-anexcelexpert.com/wp-content/uploads/PivotTables/Pivot-Table-8.4.jpg)