Advance Filter Data in Pivot Tables

To build complex filter criteria consisting of multiple filter clauses using various filter operators, you can use the Prefilter (Filter Editor):

The Prefilter doesn't affect filtering via filter dropdown lists of fields (see above).

To invoke the Prefilter, click an empty space within the Pivot Table's header region and select Show Prefilter from the context menu:

After building and applying a filter via the Prefilter, the filter panel at the bottom of the control becomes visible. It displays the current filter criteria:

To modify the current filter, open the Prefilter. You can now open it by clicking the Edit Prefilter button.