Modifying measure using MDX. How to ?

[PavelUK123]

Hi,

I have simple problem.

Ive got running cube with:

Dimensions: Item, Time
Mesure: Quantity

Current cube shows me sum of items for current time (date, year...)

What I need to help with:

How co modify this measure that it will show me all quantity till choosen time from time dimension.

For example:
2008 2009
Item1 300 310
Item2 310 315
Item3 200 200

So In year 2009 quantity reached of 10 Item1, 5 Item2 and 0 Item3.

Thank you for any help!

[PavelUK123]

I made step forward and created following MDX script:

SUM ( { [Time].[Year Name].&[Calendar 2002]
, [Time].[Year Name].&[Calendar 2003] }
, [Measures].[Quantity]
)

But it gave me only SUM between 2002 and 2003, I need to change 2003 with current choosed time scale.

Any advice?

[PavelUK123]

I made step forward and created following MDX script:

SUM ( { [Time].[Year Name].&[Calendar 2002]
, [Time].[Year Name].CurrentMember }
, [Measures].[Quantity]
)

But it gave me only SUM between 2002 and CurrentMember, I need to change &[Calendar 2002] with something like previous [Year] or [Month] or [Day ]

Any advice?