I am trying to create a calculate measure that will sum all time periods to
date.

So if I have a cube that has data for 2000 - 2004 and I select January of
2004, I would want this member to return the sum of 2000 January through 2004
Januray.

Any thoughts on how to do this?

I have tried adding a member that sums all time periods together (Total
Time). This allows me to use the PeriodsToDate() function and it works
correctly at the year level. However, I cannot get that to pass down to the
months.

Please let me know if you can think of any options.

Thank You

ytd(Month)

"nsteffin" wrote:

oops never mind - did not read properly.

sum(periodstodate([Time.Standard].CurrentMember.LEVEL.Members, [Year Current
Time Evaluation Function]), [YOUR MEASURE])

[Year Current Time Eveluation Function]
can be something like this if you have a property on each level indicating
current period:

Filter([Time.Standard].CurrentMember.LEVEL.Members,
[Time.Standard].Properties("Current") = "-1").item(0))







"nsteffin" wrote:

Could try something as simple as
Aggregate ( [Time].[Jan, 2000]: [Time].[Jan, 2004] )

"nsteffin" <nsteffin (AT) discussions (DOT) microsoft.com> wrote