Forum Discussion
Solved
Hierarchy level total
Team
i have problem in allocations in Hierarchy reports in Matrix.
Lets say i have 3 level (Age Summary / Age Group / Category) in my report
The 3 Node calclation is Closing balance * Average%
i need a calculations
in 2nd Node is sum of 3 node
in 1st Node is sum of 2 Node
i don't know clue how to proceed for this calculation
vasathi Something like this:
MEASURE =
SUMX (VALUES('TableName'[Node 3]), [Closing balance * Average% (Measure)])
It will show in node 3 your measure and will sum up the values for node 2 and aso for node 1.
5 Replies
vasathi Something like this:
MEASURE =
SUMX (VALUES('TableName'[Node 3]), [Closing balance * Average% (Measure)])
It will show in node 3 your measure and will sum up the values for node 2 and aso for node 1.
