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.