calculating opening bal

[#1]

I want to capture previous value of my closing account as opening account for the next month . Find attach excel. Gives u clue.

Note opening balance should start wt zero.

[Jacek]

example in attachment

Regards

Jacek

[chematos]

Hi,

Try to use just 1 dimension in your chart, creating MonthYear field in the loading script:

Load*,

Month&'-'&Year as MonthYear;

load*,

Month(DateID) as Month,

Year(DateID) as Year

Regards,

Jose

[#4]

When in drill down Dec 2014 doesnt post closing balance to opening balance

[#5]

I have to split into month and year to achieve what i want