Accumulated Value with Filter

[Anonymous]

Hi partners.

I would like to make the amount accumulated in my table, however I would like

that would make the accumulations of the months by the correct status.

The expression I use is: = SUM (VALUE) and I choose the option to accumulate 12 last steps

The expression value is = SUM (VALUE) but without the accumulate option checked (this is correct)

I just need some help for the accumulated value

My idea is Month of February - Status (ACTUAL) = It must add the previous month (Jan) that has the Current Status with the value of the Month of February that has the Current Status, and so for all months and status.

The result I got is this

Thank you for your help

Nicolas

[vijetas42]

Please refer RangeSum() function

[Anonymous]

Hi Vijeta, thanks for the comment.

I will study about the RangeSum function and try to apply it in my expression

Thank you

[dplr-rn]

Try accumulate option in the expression or use below

rangesum(above(Sum(Value),0,RowNo()))

basically - rangesum - sums up a range of values

above - gives values of sum(value) from row #1 (0 in qlik) to current row