Create accumulative measure for non-date dimension on SAP Analytics Cloud Table

[former_member693168]

Hi to all.

I must create a two calculated measure with a accumulative sum on a SAP Analytics Cloud table like the below scheme for accumulative x and y measures:

That is the blue value must be the sum of yellow value and gree value.

How can I do that?

[sgodfree · Accepted solution]

Hi Marcelo,

If you right-click on the row dimension/member you can select 'Add Calculation', and then 'Accumulative Sum' (or one of the variations it). This will add a new row (or multiple rows if you select repeat) and will insert a RunningSum formula.

Thanks,

Scott

[former_member693168 · Accepted solution]

Mr. Scott Godfree, your answer is exact what I need.

Thank you. God bless you a lot.

[former_member693168 · Accepted solution]

Hi Mr. Godfree, your solution works fine for me. God bless you. Thanks.