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