cancel
Showing results for
Did you mean:
Creator

## Cumulative balance pivot table within one dimension

Can someone help me out on this one?

The pivottable in the attached document shows a financial (cumulative) balance.

But it should be only cumulative every month WITHIN one year only. So when the balance goes from 2013/12 to 2014/00 it should start cumulating from 2014/00 on.

Thanks everyone in advance for the input!

1 Solution

Accepted Solutions
MVP

Can you try this:

RangeSum(Before(TOTAL Sum({<Periode=,PeriodeNew={'<=\$(vBalansPeriodMax)'}, Bron = {'result'}, RekeningType={'Balans'}>} amount), 0,

Num(Only({<Periode=,PeriodeNew={'<=\$(vBalansPeriodMax)'}, Bron = {'result'}, RekeningType={'Balans'}>}TOTAL <Periode_Met_Nul_13_Naar_12> Periode_Only)) + 1))

6 Replies
MVP

Can you try this:

RangeSum(Before(TOTAL Sum({<Periode=,PeriodeNew={'<=\$(vBalansPeriodMax)'}, Bron = {'result'}, RekeningType={'Balans'}>} amount), 0,

Num(Only({<Periode=,PeriodeNew={'<=\$(vBalansPeriodMax)'}, Bron = {'result'}, RekeningType={'Balans'}>}TOTAL <Periode_Met_Nul_13_Naar_12> Periode_Only)) + 1))

Creator
Author

Hi Sunny,

i'm truly impressed, EXACTLY what I needed, you made my day!

Kind regards,

Bart

MVP

Not a problem, I am glad I was able to help.

MVP