formule rangesum with before

francisvandergr — Wed, 26 Feb 2014 10:20:25 GMT

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.

Re: formule rangesum with before

tresB — Wed, 26 Feb 2014 10:50:22 GMT

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

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