Skip to Content
0

how to do cumulative summation in rows based on shown fields on the report

Apr 05 at 09:59 AM

45

avatar image

Hi,

Aside from using the CUMULATED IN ROWS option in query designer, how can I do the cumulative summation in rows based on shown fields on the report?

1. How will I achieve the COMPUTATION column?

2. So basically, I need to sort first the QUANTITY per plant and per material. Can I do the SORTING of keyfigures in query designer aside from using the CONDITION? Or is it the only way to achieve it?

Thank you.

Loed

delete.jpg (221.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Matthias Kadletz
Apr 06 at 09:45 AM
0

Hi Loed,

there are three different ways how you can get a cumulative display of values in a query.

- Local Calculation 'Cumulated'
- 'Cumulative Value Display' for a characteristic
- Variable of type Current Member

For more details I recommend to check the WIKI page:

Cumulative Value Display
https://wiki.scn.sap.com/wiki/x/x4ZjFg

Regards,
Matthias
------
OLAP Technology WIKI

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks a lot for the link! Idea can also be used to other scenarios. :-)

Loed

0