MDX - IIF Statement MDX Expression - OLAP Cube

[syedbokhari]

Hi Guys,

I'm trying to develop a MDX IFF expression and I can't seem to be able to write it properly as I don't usually write in MDX.

I want to have tiers based on customer life time value.

I have this IFF statment which works perfectly fine

IIF([Measures].[Lifetime Value]>500, "Yes","No")

However I want the following formula I write in excel in a MDX which will work.

Outline
IF(AND Lifetime>=500,<1000,"Bronze"),IF(AND(>=1000,<2500),"Silver",IF(AND(>=2500,<5000),"Gold",IF(AND(>5000),"Platinum","Not VIP").

I'm not the best at writing these and I will have to write it in the OLAP tools section within EXCEL 2013.

Any help will be greatly appreciated.

Thanks Chaps,

*(I may have posted this in Excel forum by accident) - Apologies