1
Can I connect my pivotslicer to multiple pivotcharts, but on different category levels, so If for example I have a categorytree that goes:
Department --> Section
If I choose "Section A" Then I can have one chart display Section A data, and 1 chart displaying the Department of Section A Data (the parent of section A)
Jakob
Posted 2013-04-03T08:22:32.920
Reputation: 195
1
Yes. You can create a pivot chart that breaks the data down by section. Create another pivot chart that breaks the data down by department.
Add a pivot slicer to the first chart for the section. Then click the data table for the second chart and click "Insert Slicer > Slicer Connections". Select the tick box next to "section".
That way, the two pivots will show the same grand total. The first will show the section only, the second chart will show the parent departments for the selected section.
Here is a link to a sample file
teylyn
Posted 2013-04-03T08:22:32.920
Reputation: 19 551
I'm trying to figure it out, but I'm having some trouble - a sample file would be much appreciated – Jakob – 2013-04-03T12:55:48.600
I added a link to a sample file above. – teylyn – 2013-04-05T00:47:17.523
Hi again - I got it working, but it actually didn't solve my problem. The issue is that the slicer is more granular than I want graph 2 to be, so instead of "zooming in" and taking child-data also. I want to "zoom out" and take parent data based on the child that is selected through the slicer – Jakob – 2013-04-06T11:29:37.987
in other words: department is above section in my data – Jakob – 2013-04-06T11:37:54.323
2Hmm. The method and sample I posted do what (I think) you describe in your question. But apparently it's not the result you desire. How about taking the guess work out of the answer attempts. Post a data sample and mock up the desired results manually. Then we at least know what to aim for. – teylyn – 2013-04-07T08:19:52.517