on 04-05-2018 10:59 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.