Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
bartvanwetten
Creator
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
sunny_talwar

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

View solution in original post

6 Replies
sunny_talwar

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
Creator
Creator
Author

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
Creator
Creator
Author

hahah sunny, sorry man, i made yours helpful.

sunny_talwar

I was just playing around with you, but thanks