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:

muti-level filter on pivot table 1

We select all of the data with Ctrl+A shortcut and insert a pivot table from INSERT ribbon.

muti-level filter on pivot table 2

Clik OK on the pivot table promp (you can check data range if you want to).

muti-level filter on pivot table 3

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)

muti-level filter on pivot table 4

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.

muti-level filter on pivot table 5

Using the field shown in the red rectangle, you can alternate between fields to filter your pivot table.

muti-level filter on pivot table 6

You can see how different selections allows you to filter by different fields from the picture below:

muti-level filter on pivot table 7

 

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *