Hello experts!
I have a simple question...
In a Pivot Table I have Dimensions and Calculated Dimensions:
Yellow: Dimensions.
White: Calculated Dimensions.
Green: Expression.
The calculated dimension is the sum of the previous dimension:
DC GRUPO SUB CANAL:
AGGR(SUM(Units), CANAL, GRUPO SUB CANAL)
I need an expression that makes the sum of Units of previous dimension, in this case the sum of Units grouped by GRUPO SUB CANAL. It is possible to make a expression of previous dimension in a Pivot Table with dimensions calculated without using AGGR? Something like that: SUM(TOTAL<Dimensións, Calculated Dimensions>Units)
Thanks a lot!!!
Regards,
Juan Pablo Rodrigues.