Posted by: sajhamitra November 8, 2012
Login in to Rate this Post:
0 
? 
?
To do this you will create a SCOPE statement. You do this on the calculation tab of the by selecting a Script Command and using the following MDX.
SCOPE ([Measures].allmembers);
FORE_COLOR(THIS) = IIF([Measures].currentmember <0 ,'255','0');
END SCOPE
SCOPE ([Measures].allmembers);
FORE_COLOR(THIS) = IIF([Measures].currentmember <0 ,'255','0');
END SCOPE