Cumulative Sum with condition

[Anonymous]

Hello everybody,

I'm not able to figure out how to solve this issue: I have a pivot table with some dimensions an expression that is the sum of a quantity (Forecast) and I'd like to have a new expression that is the cumulative sum of the "Forecast" but only for the rows with the same month.

Attached you will find an example on what I'd like to have (i.e. line 14 column G= line 14 column F+ line 2 column F)

[sunny_talwar · Accepted solution]

May be this

Aggr(RangeSum(Above(Sum(Forecast), 0, RowNo())), Name, ItemId, Month, (Year, (NUMERIC)))

[Anonymous]

Thank you very much, it works!