Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)))
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)))
Many many thx Manish! Exactly the right answer!
Can you close the thread by selecting my answer correct so that others can also use it..?
Sure sure, but the only action I can see is 'Mark as useful' ?
Whatever you can do...!