Forum Discussion
How to apply multiple filters in a pivot table to a large data set?
I have two filters I want to use in a pivot table, and my data is too large to manually check box's to filter. For the screenshot below, I'd like the "Sum of Revenue" column to only include value...
PivotTable doesn't allow to set multiple value filters. Possible workaround is to add duplicated column in source and use it as another label column in PivotTable. With that you may apply first value filter for one label column and second value filter for another one. Since label columns are identical both value filter will be applied.
More details is here filtering - Applying Multiple Value Filters in Excel Pivot - Stack Overflow in answer with Hospital and Hospital 2. Didn't check other variants.