cancel
Showing results for 
Search instead for 
Did you mean: 

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

Loed
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member274922
Participant
0 Kudos

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

Loed
Active Contributor
0 Kudos

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

Loed

Answers (0)