Hierarchy Grand Parent Total Only

[rajendrav2016]

Hi All,

I have a Employee Hierarchy upto Level 5. when i drill down to lewest level, i should see same grand total of first level parent.

Using calculate(sum(sales), All(Level2)) etc is not overwriting context instead of it is showing values within context of level2,3,4

Any Ideas

[v-jiascu-msft]

Hi @rajendrav2016,

Can you mark the proper answer as a solution please?

Best Regards,

Dale

[v-jiascu-msft]

Hi @rajendrav2016,

The Matrix visual did have a subtotals. Is it what you would like?

Best Regards,

Dale

[rajendrav2016 · Accepted solution]

No. it worked by saying all in all levels of hierarchy.