Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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))
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))
Hi Sunny,
i'm truly impressed, EXACTLY what I needed, you made my day!
Kind regards,
Bart
Not a problem, I am glad I was able to help.
Also did you want to mark my answer as helpful (instead of yours)
hahah sunny, sorry man, i made yours helpful.
I was just playing around with you, but thanks