Abdul Alim: a little bit learning, let's go

Excel, VBA and Power BI tutorials 

Chapter-3: Filters In Pivot Table

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.

After using the filter by “Product – 3″, pivot table will look like below image- 

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.

Click on Row Labels drop down arrow >> Value filters >> click on Top 10… 

Below given window will be opened. Put 5 in place of 10 and select the Sum of Revenue.

Top 5 employees will be filtered by Revenue.