Hi All,
I'm developing a report with the below format:
Product---- Period----
Error
--
Sigma Error
P1--
10
P1--
30
P1--
40
P2--
10
P2--
30
P2--
45
The Report has to display the Sigma error (Sum) at the Product and Period Level (Ex. for P1 in Feb 09 the Sigma Error is 1020 =30 and for P1 in Mar 09 the Sigma Error is 102010 = 40). For calculating these sigma values i created a calculated key Figure and i'm using the cumulative option. My issue is while calculating the Sigma Error for product P2 in Jan 09 its picking up the sigma error of P1 and its calculating as 1040 = 50 which is wrong the Sigma error for P2 in Jan 09 is only 10.
Can anyone please let me know how to fix this error, do we have any option for groping the Sigma error with respect to Product or another option that we can use while using the calculated key figure.
Thanks,
AM
Edited by: a m on Jul 3, 2009 6:16 PM