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

[sunny_talwar]

I sort of understand you issue, but can you help me understand better by pointing out the exact number you are looking to get?

[bartvanwetten]

Sunny,

you can set the dimension variable to for example 'Periode'. Than you'll get the numbers over the months. The first month of every next year should be the amount of the last month in the previous year. So it shoult cummulate over tthe months but in ONE year and not over the year. Am I making my self clear?

Thanks!

Bart

[sunny_talwar]

Where do I go to set the dimension variable? Variable Overview?

[bartvanwetten]

Yes: vPeriodeSelectieBalans

There you find the fields used for the dimension

[bartvanwetten]

Sunny,

Now I remember I asked you a very similair issue some time ago but i can't find it in my history.

Can you find history between you and me? I blessed you that day I remember

Bart

[sunny_talwar]

This?

Cumulative balance pivot table within one dimension

[bartvanwetten]

Yes,

but I see it is nog what im looking for now hmz.

Are you getting along with my challenge of today?

Thanks!

[sunny_talwar]

I want to, but I am not sure what numbers are you looking to get . May be if we can provide with me some directions, I might be able to help you out

[bartvanwetten]

Maybe we can have a skype call? and some teamviewer?