Hi,
we are having requirment like,productno, country,yearmonth and revenue
i need to add cumilate revenue if all two key field are equal for example
product Country YYMM Rev Cumilate rev
Q1 India 200701 3 3
Q1 India 200702 4 7
Q1 India 200703 6 13
Q2 India 200701 5 5
Q2 India 200707 3 8
Q3 US 200707 3 3
i need to show cumilative revenue like the above i mentioned under Cumilate rev
how i can procede
please help me
Regards,
Thanks for replay,
But Product and Country not fixed ,
it will be with different combination ,but we need to add if both are equal only.
where can i get Cumilate option in restricted key figure
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
just right click on the Restricted KF and select the properties.. u will find the option...
Khaja
Create a Calculated Key Fig with Exception Aggregation as Summation with reference Characteristic on Product.
Goto the properties of the Key Fig and Tick the Checkbox Cumulated
Select Also Apply to the Result and Along The Rows
If u want to show it in 2 different columns then use restricted kf's... and make the properties as cumulative....
The another option is to use Cell definition if the product and the country are fixed......
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.