accumulate in pivot table

[bartvanwetten]

Dear all,

can someone help me out on this one?

Attached you find a sheet (red marked) with a pivot table. (Financial balance)

The amounts are already cummulated but it should cumulate only in one year and not over the year.

In fact, the end of year 2014 should be the same as the beginning of 2015 and so on.

Thanks in advance!

Bar

[bartvanwetten]

Hi Sunny,

As soon as another year starts it starts with month 00. Wich is the cum.amount of the year before.

So every year it shout start cumulating from 00 on. So cumulate 201400 to 2014 12, then cumulate new from 201500 to 201512. What it dow now is cumulate from 201400 to 201609. It should cumulate in the year only.

Ok?

Thx for waching again!

[bartvanwetten]

Range Sum Iterate Over Years

Sunny it looks like the solution is to find in above discussion, but i can't get it into the formula in the first attachment.

Please help? If you like I will be pleased to offer you a fee!

Regards,

Bart