balances

[#1]

I want to capture previous value of my closing account as opening account for the next month . scenario

Year	Month	Opening balance	Closing Balance
2011	Jan	0	237
2011	Sep	237	445
2012	Feb	445	679
2012	Nov	679
			x
Day n		x

Also date; i have about 16 months in which all other 4 months are merged into december. Find attached QVW ffile

[#2]

When i placed this expression on drill down Year>>Month it couldn't carry Dec closing balance to Jan

[petter]

Well the drill-down essentially removes the year ... so then you will have to have a combined YearMonth dimension as I mentioned earlier ...

[#4]

Thanks Petter,

But I want it to drill down

[#5]

Yes am using Pivot table and wants it to drill down from Year>>Month Above wont give accurate value. I think Previous will do, but have not gotten the correct syntax

[Jacek]

I understand Your problem. It isn`t easy. According to your qvw file - table on left with [Above] is good for YEAR and MONTHS except for January.

My proposition:

1) You can count (in resident load) values for each January for all Years (by previous value from December, previous Year).

2) After, in expression of table, make IF condition to January (show counted values), but to others months use [Above]

It will by good if You do not use other filtres than Date.

Regards

Jacek

[#7]

My issues persists