cancel
Showing results for 
Search instead for 
Did you mean: 

Cumulative Value in row

Former Member
0 Kudos

Hi All !

I am having scenarion in BEX:

Material Group Fiscal Yr/Period Sales Qty

-


-


-


X 09.2005 100

10.2005 150

11.2005 200

Total 450

But, I want the sales qty values to be cummulative i.e it should be like this:

Material Group Fiscal Yr/Period Sales Qty

-


-


-


X 09.2005 100

10.2005 250

11.2005 450

Total 450

Please give me some tips on gow this scenario can be acheived?? Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Go to Query Designer, right click on Key figure -- > properties --> check the cumulatives.

regards

VC

Answers (2)

Answers (2)

Former Member
0 Kudos

dear Madhusudan,

try the following int he BEx..

SAles Qty->right click properties->check cumulated and use across the rows..

hope this helps!

regards,

hari

michael_koch9
Active Participant
0 Kudos

Hi,

go to the properties of the keyfigure in query designer, right click on it.

Ther you should have the option to cumulate the value.

Here ist it descriped in the documentation:

http://help.sap.com/saphelp_bw30b/helpdata/en/d2/02223c5f00612be10000000a11402f/content.htm

Regards

Marcus