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