Forum Discussion
Merging filters in PivotTable
Hello I have an Excel file with PivotTable Fields. In one of the fields it has 50 filters that can be selected. I only want 5 of these filters to work with. What I would like to do is select thos...
If you're not using Power Pivot then you could add an extra column to the source table of your Pivot and copy down an XLOOKUP or INDEX MATCH formula that references a table that classifies your 5 items and 45 other items