Hi guys,
 Any one here can solve the following issue ;

I have a cube in SSAS with sales measure, Sales Measure which is a fact table has Sales Amount, Tax, Order Quantity etc. Now,my question is, how do I get the sales amount column appear color appear red or green depending on the sales amount eg. <5000 ..

I also have a calculated member Average sales , which i computed as Measures.SalesAmount/Measures.OrderQuantity and there I tried the following conditions but, I get the Average Sales column colored and nothing in the sales amount column..I want to get the sales amount color change depending on the conditions.

I have attached jpeg file for reference. 

Thanks for your help.


IFF([Measures].[Sales Amount]>50,255,65280)