formule rangesum with before

[francisvandergr]

I have build a formula with the following expression :

rangesum(sum(Amount*-1),before(Sum(Amount*-1),1,ColumnNo()))

The dimension of my pivot table is period.

The sort of period is desc. so  the newest period is my first column. I have included an example. I have no problem with sort asc.

So

[tresB]

Use After() with a trick for Desc sort like the following:

=RangeSum(Sum(Amount*-1), After(Sum(Amount*-1),1, NoOfColumns() - ColumnNo()))