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.

__________

Share and Enjoy

  • Facebook
  • Twitter
  • Google Plus
  • LinkedIn
This entry was posted in Excel Pivot Tables, Pivot Table, pivot table filters. Bookmark the permalink.

6 Responses to Apply Multiple Filters to Pivot Table Field

  1. Terry says:

    Fantastic video. Precise, accurate and to the point.

    THANK YOU!

  2. Jo says:

    Great, thanks for this.

  3. paul says:

    Awesome!

  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.
    thanks

  6. Germain says:

    Hi

    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).

    Thanks
    GR

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>