Filtered Pivot Tables Losing Filters When Slicer Changed. How Can I Prevent This?

trikky

New Member
Joined
Dec 28, 2016
Messages
32
I have one data source with multiple columns - for the purpose of this question, the column I'm concerned about is Category.

The Category has several choices available - Cat 1, Cat 2, Cat 3, Cat 4, Cat 5, Cat 6 & Cat 7.

I need to display scores from Cat 1, 2, 3 and 5 as a pie chart, so I have created pivotcharts for each of those.

Now, when setting up the data for each of those pivotcharts, I have added Category to the Report Filter area on the field list, and then adjusted the filter as appropriate. For example, the first pivot chart is filtered for Cat 1, the second Cat 2, etc.

Now, it's all well and good, but once I connect some slicers to show data based on month, person, location, etc, and start using those slicers, suddenly all 4 of the pivotcharts (and the pivottables they use as their source) are unfiltered and showing identical data based on the slicer selection.

I have tried selecting "allow multiple filters per field" from the PivotTable Options - no luck with that.
I have tried cutting the pivottable, pasting to another workbook, changing the filter and then bringing it back - also no luck with that.

I DO need the filters in place since I want to be able to see all 4 chosen categories displayed at the same time, with the stats for the appropriate slicer selections.

What's going on, and why am I losing my mind? :)
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Figured it out.

One of the slicers was based on Category so of course when I used that slicer (I was just clicking on all the slicers to check the data changed) the filter was removed.

Still a little silly that happens, but I can understand why.

Problem solved, thanks for your time and for being here.
 
Upvote 0

Forum statistics

Threads
1,223,236
Messages
6,170,912
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top