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?
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?