Shane Aldrich
New Member
Hi All… Is this even possible??? I’d like to have a slicer that displays hierarchy levels by grouping. In the example, there are 4 sheets…
PowerView1 – an example that someone helped by build, I’d say this can be ignored, but not sure if anything will break…
Tables – the data that’s been loaded into the data model…
“Good_Pivot” – this pivot “works” in that the formulas are calculating correctly, but I’d like to get away from a pivot table layout that requires me to expand as I drill down into hierarchy level…
“Bad_Pivot” this sheet functions as I like with levels, meaning if I want to see a groupings results, I click the desired level, and that’s all that displays. Unfortunately, the formulas for targets/attainment are not calculating correctly.
I’ve made several attempts at tweaking other formulas versions, but no luck…
My gut is telling me I need to use a iscrossfiltered function, but maybe not…
My first post….any help is greatly appreciated,
Shane
PowerView1 – an example that someone helped by build, I’d say this can be ignored, but not sure if anything will break…
Tables – the data that’s been loaded into the data model…
“Good_Pivot” – this pivot “works” in that the formulas are calculating correctly, but I’d like to get away from a pivot table layout that requires me to expand as I drill down into hierarchy level…
“Bad_Pivot” this sheet functions as I like with levels, meaning if I want to see a groupings results, I click the desired level, and that’s all that displays. Unfortunately, the formulas for targets/attainment are not calculating correctly.
I’ve made several attempts at tweaking other formulas versions, but no luck…
My gut is telling me I need to use a iscrossfiltered function, but maybe not…
My first post….any help is greatly appreciated,
Shane