Skip to Content
0
Jun 22 at 07:49 PM

SAP Analytics Cloud Accumulated Sum for specific Dimension

107 Views

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

image.png

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

image.png

Attachments

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