Skip to Content
Jun 22 at 07:49 PM

SAP Analytics Cloud Accumulated Sum for specific Dimension


I have seen where I can add a Calculation on a column like Accumulative Sum, but this will create a running total for all rows in the table. I want the running sum to reset for every new member of a dimension like Material Number Similar to the example below.

I have looked through other posts and have not found a solution for this or way to control when the accumulative sum resets by a dimension member.

This is what I want, where Accumulative Qty resets with each new material number


This is what I get where the running total keeps accumulating across all rows regardless of material number.



image.png (17.5 kB)
image.png (17.7 kB)