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.
__________
Fantastic video. Precise, accurate and to the point.
THANK YOU!
Great, thanks for this.
Awesome!
Thank you, thank you, thank you! You just made my life so much easier!
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
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