Selection should not effect the chart

[kunkumnaveen]

Hello All,

I need to write a set analysis under color such that ,the below expression should remains unchanged  when i selected a Dimension

Dimension:Management

Expression:

if(SRMM_Criteria_Color='RED-FUNDING',RGB(255,0,0),Green())

How to write the above expression in set analysis

Thanks

[tresB · Accepted solution]

Try like:

Only({1} if(SRMM_Criteria_Color='RED-FUNDING',RGB(255,0,0),Green()))

[kunkumnaveen]

Thanks .....Working