Value filters on multiple value columns in a Pivot Table
Greetings,
I know how to utilize the ‘Value Filters’ functionality in order to filter Pivot Table data. Is there a way to filter on the values in 2 separate columns? I need my Pivot table results to show rows that have a counts >1K AND an Index comparison value <1.00. Currently, I can only do one filter or the other, but not both – is there a way to do this?
Thank you!
Greetings, I know how to utilize the ‘Value Filters’ functionality in order to filter Pivot Table data. Is there a way to filter on the values in 2 separate columns? I need my Pivot table results to show rows that have a counts >1K AND an Index comparison value <1.00. Currently, I can only do one filter or the other, but not both – is there a way to do this? Thank you! Read More