Multi-Level Filter On Pivot Table
Filtering pivot tables with more than one field at the same time is possible and easy. Here is a guide about how to set up multi-level filter on pivot table.
After learning how to set up pivot table row labels on the same line, we can set up multi-level filter on pivot table almost effortlessly. Because it gets set up automatically as you setup your pivot table in a certain way.
Step by step guide to set up multi-level filters :
Here is a sample sales data of a tech reseller company:
We select all of the data with Ctrl+A shortcut and insert a pivot table from INSERT ribbon.
Clik OK on the pivot table promp (you can check data range if you want to).
We need to set up our pivot table as below:
(you can learn how to do this kind of setup from pivot table row labels on the same line post)
As you see, we have 3 fields setup as
When you click on the pivot filter you can see a multi-level filter on pivot table.
Using the field shown in the red rectangle, you can alternate between fields to filter your pivot table.
You can see how different selections allows you to filter by different fields from the picture below: