Cumulative in pivot table (financial balance, debtors)

[bartvanwetten]

Hi all,

in attached document there is a pivot table with a financial balance with Debtors. I can't get it cumulative. I used rangesum() but somehow I never get the needed result. There's a picture in it with the right cumulative results in Excel.

Thx everyone!

Bart

[MK_QSL · Accepted solution]

Use

=rangesum(Before(TOTAL Sum({<Hoofdgroep ={'3'},Subgroep={'2'}, Bron = {'result'}, RekeningType={'Balans'}>} amount),0,ColumnNo(Total)))

or

=rangesum(Before(Sum({<Hoofdgroep ={'3'},Subgroep={'2'}, Bron = {'result'}, RekeningType={'Balans'}>} amount),0,ColumnNo(Total)))

[bartvanwetten]

Many many thx Manish! Exactly the right answer!

[MK_QSL]

Can you close the thread by selecting my answer correct so that others can also use it..?

[bartvanwetten]

Sure sure, but the only action I can see is 'Mark as useful' ?

[MK_QSL]

Whatever you can do...!