Skip to Content

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 06 at 09:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded