Abdul Alim: a little bit learning, let's go
Excel, VBA and Power BI tutorials
Abdul Alim: a little bit learning, let's go
Excel, VBA and Power BI tutorials
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 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.