Skip to Content
0
Former Member
Jul 02, 2009 at 05:55 AM

Restting the Period Count

30 Views

Hi,

I'm creating a report that should look like as shown below:

Material -


Month -


Period--


Error--


Cumulative Error

M1--


01/2009 -
1
10
--


10

M1--


02/2009 -
2 -
10--


20

M1--


03/2009 -
3--


20 -


40

M2--


01/2009 -
1--


10 -


10

M2--


02/2009 -
2--


5 -


15

M2--


05/2009 -
3
10
--


25

My issue is how can i restart numbering the Periods from " 1" when ever there is a new material added to the result table. (Ex from M1 to M2).

When calculating the Cumulative Error how can i reset the cumulative error when ever a new material is added (Ex. for the first record of M2 the cumulative error should be the error of the first record for material M2 and then it should cumulate the error for all the record for material M2).

Please let me know how we can design the above query using calculated keyfigures.

Thanks,

AM

Edited by: a m on Jul 2, 2009 7:55 AM