Hello,
I am trying to develop an expression in a pivot table which should sum the values which are under the same hierarchy.
Dimension1 |
Measure |
TOTAL C2&C3 |
3 M1=M2+M3 |
C2 |
1 M2 |
C3 |
2 M3 |
TOTAL C5&C6 |
7 M4=M5+M6 |
C5 |
3 M5 |
C6 |
4 M6 |
Please find the table above as an example, but please in mind that it's a pivot table. Also, the Totals functionality from the dimension cannot be used, it has to be done from the expresion. The rule is that the rows should be summed until the word "TOTAL" is found in the dimension.
Thank you in advance!