Thanks Keith,
I've tried this syntax in AS on the calculated cell:
with
member measures.Amt as ' sum( { PeriodsToDate(Time.Year, Time.Month.currentmember) } , measures.currentmember ) '
select { [measures].measureslevel.allmembers } on columns,
{ [Time].[Month].members } on rows from Test
but get a syntax error:
'expecting SELECT, near: 'sum({PeriodsToDate(Time.Year, Time.Month.currentmember)}..........
The member is called 'OPENING BALANCE' that requires the calculated cell and is located in the REPSECT dimension:
REPSECT
..=> CASHFLOW
....=> NETINCOME
......=> OPENING BALANCE
The time dimension is YEAR=>MONTH
For example, the 'OPENING BALANCE' should be calculated from the previous month's 'CASHFLOW' total:
................................2003
................................November..........December
REPSECT
....CASHFLOW
........Net Income
...........Opening Balance........R 100,000.00...R 110,000.00
...........Current Debtors.........R 20,000.00....R 30,000.00
........Net Income Total..........R 120,000.00...R 140,000.00
........Current Creditors.........-R 10,000.00...-R 40,000.00
....CASHFLOW Total................R 110,000.00...R 100,000.00
Again, thanks for your help
Andre