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...
Thanks for your response. I already have a Pivot Table that was sent to me, that has pre-set filters. Under one of the filters is 50 categories, I want to combine 5 of those 50 into a single category. I'm unsure how to use a mapping table, any help would be great. Thanks
I'm not quite clear on what you mean, but you may be able to Ctrl select multiple items and group them and then use them as a filter