SAP Analytics Cloud: Cumulative sum charts

[Former Member]

Dear all,

is it possible to add an cumulative sum calculation for a measure in a chart? I only found the possibility for tables but urgently need the functionality in charts. I am aware of the YtD calculation but unfortunately, I need an aggregation across the fiscal years.

Thanks for your support,

Leonie

[amitrathi239]

can you pls explain with chart screenshot

[former_member898937]

Hello,

I tried the methods in this article https://www.linkedin.com/pulse/4-ways-calculate-accumulative-sum-sap-analytics-cloud-t%C4%83lmaciu/ but they dont work with an aggregation, you can however use the cumulative and maybe turn that into the aggregation later?

[former_member234401]

Hi you can use the posting date and change that via a formula - change that to a date dimension

Only time dimensions can be used for running totals in a chart - this has been postponed multiple times - and should be available end 2019 if they do not postpone it again