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 change in material in 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