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