This Excel VBA tutorial explains how to apply multiple criteria in Label Filter of Pivot Table.
Problem with multiple criteria in Label Filter of Pivot Table
There are three kinds of Filters in Pivot Table for each Pivot Filters - Label Filter, Value Filter, Manual Filter. In this tutorial, I will focus on Label Filter, because I use "Department" as an example, which is non-numerical.
Suppose you have the below Pivot Table and you want to show Department Name contains "Fin" and "Aud".
...
Read More