background color expression

[didierodayo]

Hello,

I have this scenario for background color and it is not working atm.

I have 2 tables as attached and they are not linked. I would like to set the color for city on table 1 to green if the city in table 1 is equal to the city in table 2 otherwise red.

at the moment it works fine only when I select the city in table 2 otherwise by default everything is red.

What I need is for the background expression to check table2 and load the appropriate color even without selection.

how could this be written?

Your assistance is appreciated.

Thanks

Didier

[sunny_talwar · Accepted solution]

May be this:

If(Avg({<City = p(City1)>} 1) = 1, GREEN(), RED())

[didierodayo]

Thanks a lot Sunny for all your help really appreciate.It worked.

I have one question though, If I didn't want the '1' TO SHOW inside the color is there a way to keep it as pivot table but only have the color showing?

[sunny_talwar]

Use the same expression for your text color