Hi,

I have the following situation

Paid Year Paid Period Paid Amount

2006 1 100
2006 2 200
2006 4 150
2006 5 100
2006 7 300


I need to show the data for each month in 2006 in my cube as follows

Paid Year Paid Period Paid Amount till date
2006 1 100
2006 2 300
2006 3 300
2006 4 450
2006 5 550
2006 6 550
2006 7 850
2006 8 850

This is assuming that i have data loaded till Aug 2006 in my RDBMS. So
basically it should calculate till date amount for all missing periods
but only till the max month for which data has been loaded in RDBMS. It
should not calculate this for future months.

How can i do this in AS2000. I use pivot table to access my cubes.

Anup