Cumulative balance pivot table within one dimension

[bartvanwetten]

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!

[sunny_talwar · Accepted solution]

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

[bartvanwetten]

Hi Sunny,

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

Kind regards,

Bart

[sunny_talwar]

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

[sunny_talwar]

Also did you want to mark my answer as helpful (instead of yours)

[bartvanwetten]

hahah sunny, sorry man, i made yours helpful.

[sunny_talwar]

I was just playing around with you, but thanks