Hi everyone

I am new to MDX. I have two questions.

Q1.
I have two measures total, subtot

I want to create calculated member based on following condition

if calendar dimension level is year display total
else subtotal


Q2.

I am getting following error msg. while using Levels("Calendar") in
calculated member builder,

ERROR MSG.

unable to update the calculated member.
Formula - Cannot convert level to expression in the levels(<string>)
function



Can anyone help me,


Thanks
Kalyan

IIF(Calendar.CurrentMember.Level.Name = "Year",
[Measures].[Total],[Measures].[SubTotal])

Vimmas


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