Use of Above() or accumulation

[curiousfellow]

I'm trying to understand the Above() function.

However I don't get the results I expect.

My main goal is to get a pivot table with a running total per dimension.

I tried many examples from this forum but nothing worked. Even the accumulation option doesn't work.

Feel rather dumb about this.

Could you give some hints ?

Thanks in advance

[settu_periasamy · Accepted solution]

Try this.

=RangeSum(Above(Sum(points),0,RowNo()))

[qlikmsg4u]

See the attached

[curiousfellow]

I get a continuous running total, without taking into account the change of the dimension.

[curiousfellow]

Thank you very much for this fast answer.

Could you please explain this part : 0,RowNo() ?

[settu_periasamy]

Hi,

0 is the offset value. rowno() will increase based on the row till the dimension end.

so, it will work like

0  to 1 - first row,

0 to 2 - till second row,

0 to 3 - till third row

Check the below document give the clarity

Missing Manual - Above() and Below()