I am getting the following results in a Crosstab over a Cube:
Ttl Sls Comp Sls
TY TY% LY%
Div 1 200 2 1
Div 2 100 1 -1
Div1/2 300 3 0
where Div1/2 is a calculated member in the report ([Div1] + [Div2]).
Ttl Sls TY and Comp Sls are measures defined in the Cube.
TY%/LY% are calculated in the cube as part of a Year Hierarchy:
TY% = (TY - LY) / LY
LY% = (LY - LLY) / LLY
where TY, LY, and LLY are the base members of the Year Hierarchy.
In my calculated member, sales values are accumulating as Totals which is correct, but Percentages are also accumulating as Totals!
I have tried changing the Solve order to rectify, but I am not getting the results I wish.
I think I am just missing something very simple!
Any help would be greatly appreciated.
Thanks in advance,
Adam
I resolved this issue by using the following calculation instead of the Calculated Member:
Div1/2 = aggregate(currentMeasure within set set ([Div1],[Div2]) )
Then set to the appropriate Solve Order.