# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Contributor

## Cumulative in pivot table (financial balance, debtors)

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

Tags (3)
1 Solution

Accepted Solutions
MVP

## Re: Cumulative in pivot table (financial balance, debtors)

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)))

5 Replies
MVP

## Re: Cumulative in pivot table (financial balance, debtors)

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)))

Contributor

## Re: Cumulative in pivot table (financial balance, debtors)

Many many thx Manish! Exactly the right answer!

MVP

## Re: Cumulative in pivot table (financial balance, debtors)

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

Contributor

## Re: Cumulative in pivot table (financial balance, debtors)

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

MVP

## Re: Cumulative in pivot table (financial balance, debtors)

Whatever you can do...!