Skip to Content
0
Former Member
Jul 03, 2009 at 04:16 PM

cummulative using calculated key figures

22 Views

Hi All,

I'm developing a report with the below format:

Product---- Period---- Error --


Sigma Error

P1--


Jan 09-- 10 --


10

P1--


Feb 09-- 20 --


30

P1--


Mar09-- -10 --


40

P2--


Jan09-- 10 --


10

P2--


Feb09-- 20 --


30

P2--


Mar09-- 15 --


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