I have successfully set up a YTD and MTD measure for a Calendar Year
time dimension. Using the following code to set up calculated measures:

Sum({Ytd()},([Measures].[Volume])) and

Sum({Mtd()},([Measures].[Volume]))

However these do not display when I change from the Calendar Year
dimension to a Financial Year dimension (both set up using the
predefined time dimensions).

Can anyone help?

Thanks in advance
Emily

--
Posted via http://dbforums.com

You might have to make two additional versions for the financial year
dimension. YTD()-function use Time.CurrentMember as default. So if you make
a new calculated measure with YTD([FinancialTime].CurrentMember) that can
help you.

There are even better solutions if you have a look at www.tomchester.net and
look for a sample called called a calculation dimension.

HTH
Thomas Ivarsson

"Emily" <member32827 (AT) dbforums (DOT) com> wrote