I need to change the background color of field in a straight table based on a value that is not being included in the straight table. For example, I want to change the background color of the user name who ever worked in Pennsylvania. However the state names are NOT being displayed in the table. Only the user name and a series of measures.
|Name||# of Calls||# of Days Worked||# of Complaints|
Tom worked in Pennsylvania.
Thanks in advance for your help!
This works fine if a person only has 1 state. But my data has multiple states for each person. How can I find PA in the list of all the states that a name has?