Apply Multiple Filters to Pivot Table Field

A powerful feature of pivot tables is that you can filter a pivot field, to see specific results. However, if you apply a different filter to that pivot field, the first filter is removed. For example, if you filter a Row field for region names starting with "East", and then add a Top 10 filter, the "East" filter is removed.

Use the technique shown in this video to apply multiple pivot table filters at the same time. You can use a Label filter, Value filter and Manual filter simultaneously, to fine tune your pivot table reports.


This entry was posted in Sort and Filter. Bookmark the permalink.

6 Responses to Apply Multiple Filters to Pivot Table Field

  1. Terry says:

    Fantastic video. Precise, accurate and to the point.


  2. Jo says:

    Great, thanks for this.

  3. paul says:


  4. John says:

    Thank you, thank you, thank you! You just made my life so much easier! 🙂

  5. Damir says:

    how to apply multiple VALUE filters?
    i have more than one field in the value area, and i want to filter on more of them.

  6. Germain says:


    Is there a way to “or” the filters?

    Say I’ve got a list of 20 products and I want to show the TOP 10 + one specific product (by name).


Leave a Reply

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