dynamic gauge settings

[#1]

Hi,

I have a pivot table and with a Process name and measures like Actual, Target and Trend. It looks like this:

ProcName Actual Target Trend

Test1 85,0 91,0 93,0

Test2 1,7 2,0 1,9

Test3 110,0 100,0 109,0

In my expression box I created a expression with as representation a traffic light gauge. In this gauge I want to see 3 colours:

-1. GREEN= Actual<Target

-2. YELLOW=Actual=Target

-3. Red= Actual>Target

Any idea how to do this?

Kind regards

Maarten

[#2]

Hello,

Maybe this will be helpful attached is the application

Talha

[#3]

attaches the file again

[#4]

Try again