visual clues

[#1]

Hi,

In visual clues i am not able to set the colors based on expressions.

Like if i want to highlight measure1 in green,if it is greater than measure2,eventhough i write a exopression in visual clues only one color is comming..................i want it to be done in visual clues itself and not in the expression for the background color under expressions tab.

pLEASE HELP.

Thanks in advance.

[kji]

Visual cue vales that are expressions, are not calculated for each row of data, but for the current state of your selections so you can only use to relate different column values. To do comparisons row by row you would have to use the Text Color subexpression on your expressions.

[#3]

Hi,

I hope it will work.Better you try in Expression part instead of trying in Visual Cues

[#4]

Try below expression tos how different colors for matching criterias:

=IF(sum(Sales) >= sum(Budget), green(), red())