I am working on a requirement where I am supposed to show colors for a background of field on the report based on some value set in another table. How do I accomplish this requirement?

 

I tried this statement

If({Table.Column} = "SomeValue") then "SomeOtherValue"

but {Table.Column} is always returning the first value in that column.

 

I appreciate if some one can help me here.

 

Thanks,