This [MS] support article should help you:

http://support.microsoft.com/default...en-us%3B301637
View products that this article applies to.

This article was previously published under Q301637

SUMMARY
In a number of applications and business reports you want to obtain or
return cumulative values for one or more measures. This article
illustrates the use of the SUM, PeriodsToDate, YTD, QTD, and ITEM
functions to return cumulative values over a period of time.
...
Add a new calculated member with the following properties: Parent
Dimension: Measures
Name : Sales Year To Date
Value : SUM(YTD(),[Measures].[Unit Sales])
Format String : STANDARD

Click OK to save the calculated member. This calculated member returns
the value of the Unit Sales measure for the year to date.
...

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Ok thanks Deepak. I'll give it a try.


"Deepak Puri" wrote: