hi every body ,
i need your help
I need to change the calculation of subtotals by including a hierarchy.
I managed to recalculate the subtotals but roll back in hierarchy it puts me an error message.
I joins a workbook to explain my need.
To calculate the subtotel , i use this method (If you have another method I would be happy too, more dynamic )
IF MIN([Region])==MAX([Region]) THEN
IF MIN([Segment])==MAX([Segment]) THEN
IF MIN([Product])==MAX([Product]) THEN
SUM([Value])/[Segment Total]
ELSE
SUM([Value])/[Region Total]
END
ELSE
SUM([Value])/[Grand Total]
END
ELSE
SUM([Value])/[Grand Total]
END
Thanks you for your help, it's urgent please
Not sure I catch your issue correctly or not,
But if this is the result you are seeking, follow below pretty simple procedure.
Calculate sum of sales beforehand.
[sales sum]
sum([Sales])
Then put this both for abs value and % of total with using pane.
Thanks,
Shin
