Cumilative value

[#1]

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,

[manohar_m1]

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

[Former Member]

just right click on the Restricted KF and select the properties.. u will find the option...

Khaja

[Former Member]

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