Hi I have a question

I have a table like this

Year Month value
2003 1 10
2003 2 11
2003 4 12
2003 5 13
2003 6 14
2003 7 15
2003 8 16
2003 9 17
2003 10 18
2003 11 19
2003 12 20

I have create a cube with 1 dimension (time), 2 levels (year, month) and 1
measure (value),
now I need to create another level dynamically create can permit me to
create a running-sum,
so when I select month 6 the sum of measure should be 10+11+12+13+14+15+16.
Ex.

If I select:
Year = 2003
Month = 1
sum of value measure should be = 10

If I select
Year = 2003
Month = 2
sum of value measure should be = 21


Is possible to do this ?

Thanks in advance


Simon

Try something like

Sum({[time].[2003].FirstSibling:[time].
[2003].currentmember},[measures].[value])

HTH Lutz