SAP Analytics Cloud calculate running total on story table

[former_member560909]

Hi.

i got a story including table with two columns (date, sales amount). is it possible to add third column with running totals?

[former_member207052 · Accepted solution]

Hello,

If you would just like to have a running total, you could simply use formula (see below). This would not be as neat as having an out of the box function. But still it works.

[former_member560909 · Accepted solution]

Yeaaaah! this works! thanks a lot. i even didn't know its possible to use such a formulas directly in the table control.

[former_member560909 · Accepted solution]

Hello!

by the way, do you know if there is any way to calculate running total on the model level, not in the story?

i tried to, using lookup formula, but unsucceeded

[former_member598240]

There is a feature called Accumulative Sum when clicking on a measure/account. Is this what you are looking for?

Result:

[TammyPowlas]

Hello - there are a couple of requests for this in the Continuous Influence sessions - https://influence.sap.com/sap/ino/#/idea/211842 -

https://influence.sap.com/sap/ino/#/idea/140230

I recommend voting for them.

[former_member560909]

thanks, voted