Hello, I have a time dimension. That I created using a table. I did
not have anlysis server parse out the time field. The time dimension
goes as follows.
Year->Quarter->month->week->day

I also have a measure called sales. What I would like to do is create
a cummulative total by week. i.e. the data should look as follows.
Total Cummulative Total
week1 200 200
week2 150 350
week3 200 550

How do I do this in analysis server using MDX?

Thanks in advance,

David

Create a calc something like this:

SUM(YTD(), MyMeasure)

public @ the domain below
www.tomchester.net

"David" <davidmontgom (AT) hotmail (DOT) com> wrote