Hi

I have calendar dimension with year as level

This is my data

2002 32
2003 58
2004 61
2005 66
2006 28

I want to create calculated measure for following condition

IF 2006 is selected display 28
ELSE sum(32+58+61+66)

Even user select 2002 or 2003 or 2004 or 2005 still i want to display sum
of all the year except 2006

Thanks
Kalyan


thanks
kalyan