Hi all,
I have several pivot tables based on the same cube and connected slicers cross all of them.
Unfortunately the slicers act independently of each-other. I.e; I have a dimension hierarchy of 9 levels. If I filter my pivot tables using slicers on level 3, I would like to only be able to filter the remaining values in level 4 (dependent on my previous level 3 selection). This is essential because on level 9 there are 10 000 values - hence these needs to be limited down through the previous levels.
I expect this has something to do with the data source being a cube? I have googled and found the exact issue some places, for example here;
https://powerpivotpro.com/2014/04/cross-filtering-in-slicers-with-cube-formulas/
But they all refer to powerpivots, not basic excel pivots. Hence the work-around does not work for me. I really want to avoid making a powerpivot solution, because the tool I am creating will be used by a lot of people.
Anyone who can help me
? All guidance is highly appreciated,
/Gnoke
I have several pivot tables based on the same cube and connected slicers cross all of them.
Unfortunately the slicers act independently of each-other. I.e; I have a dimension hierarchy of 9 levels. If I filter my pivot tables using slicers on level 3, I would like to only be able to filter the remaining values in level 4 (dependent on my previous level 3 selection). This is essential because on level 9 there are 10 000 values - hence these needs to be limited down through the previous levels.
I expect this has something to do with the data source being a cube? I have googled and found the exact issue some places, for example here;
https://powerpivotpro.com/2014/04/cross-filtering-in-slicers-with-cube-formulas/
But they all refer to powerpivots, not basic excel pivots. Hence the work-around does not work for me. I really want to avoid making a powerpivot solution, because the tool I am creating will be used by a lot of people.
Anyone who can help me
? All guidance is highly appreciated,/Gnoke
