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.

__________

6 thoughts on “Apply Multiple Filters to Pivot Table Field”

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

  2. 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 to John Cancel reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.