Cumulative sum in analytics

[#1]

Hi everyone,

I would like to calculate a cumulative total based on other cells in a dataset, is there any way to achieve this in SAP Analytics Cloud?

I know that with YTD you can have a cumulative total, however this is only based on dates.

Example of what I want to achieve:

Station_ID TestDate numberOfUse RowNumber cumulative_Use

256 2021-06-17 13 1 13

256 2021-06-18 4 2 17

256 2021-06-21 1 3 18

256 2021-06-22 1 4 19

267 2020-02-03 5 5 5

267 2020-02-04 6 6 11

267 2020-02-06 6 7 17

[Jay_Gandhi]

Hi a.kallali,

Have you tried either the native story feature for 'Show Totals' or in a calculation the GRANDTOTAL feature?
You could also try the 'aggregation' calculation type in a calculation to see if that helps.

Modifying a Table - SAP Help Portal

2540008 - How to use and customize totals in SAP Analytics Cloud?

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/3b7c99a7a7cd4a29bb1c5132d...

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/LATEST/en-US/a64893e144f544bbaeade663ff...

Jay

[abdelmonaam_kallali52]

Hi Jay and Thank you for your prompt response.

However, neither total nor aggregation would fulfill my need, as total will be at the end and aggregation will group my rows, what I need is to calculate the sum up to the row I am in and if the value of the first column changes (station_ID) the cumulative sum will start again.

As you may see in the table I provided, the four first rows are cumulative and the last three are another set of cumulative calculation.

[Jay_Gandhi]

I see now, I wasn't clear on the table you provided earlier.

I'm not sure how to perform a 'sumif' type statement in SAC on-the-fly in that manner and even looking thru the table calcuations: Creating Calculations from Table Rows or Columns - SAP Help Portal nothing immediately obvious jumps out.

Perhaps someone else has come up with a creative solve for this type of use case.

Jay

[abdelmonaam_kallali52]

Sorry that it wasn't clear, the copy and paste of the table took out all the tabs and spaces.

I will look at the link you provided and see.

Thanks again.