How to use an aggregation in a chart of type "Stacked Area"

[former_member355106]

Hello together,

in our story that there exists a table and a chart of type Trend (Stacked Are)a and both are based on the same model.

In the table we use the calculation of type "Acumulative Sum" which takes the value of the last periode and adds it to the value of the current period:

In the chart of type Trend "Stacked Area" we would like to use this measure (Accumulative Sum) but this is not possible. For this reason we were searching for the same formula to create an Accumulative Sum for the values marked with green but could not find anything as the calculation like shown in the table is not available:

How we could do the same calculation for the green marked values?

[IvervandeZand · Accepted solution]

Hi Oliver, suggest you take a look here: https://www.linkedin.com/pulse/4-ways-calculate-accumulative-sum-sap-analytics-cloud-t%C4%83lmaciu/ ... these do require a Time dimension. Do you have that in your Stacked Area?