Forum Discussion
conditional formatting lost when USERELATIONSHIP ist used
I just came to an solution, I used for the processing quality also a measure with USERELATIONSHIP and then used coniditonal formatting, that solved the Problem.
The issue I'm facing is with the "processing quality" column, which has conditional formatting. Specifically, cells that indicate "on-time processing" have a green checkmark, while cells that indicate "SLA exceeded" have a red cross and a red background.
However, when I filter by Sales Manager "Christian," I get all the data based on my helper column (the last column in the table). The problem is that the formatting disappears for all ZIP codes where the Creator ZIP does not belong to Christian. Since he is the Processor, the formatting should still be applied.
Here is also a screenshot.
ps.: the second ZIP should be the processor ZIP.
Unfortunatly i couldn't insert the tables in one message.
I just came to an solution, I used for the processing quality also a measure with USERELATIONSHIP and then used coniditonal formatting, that solved the Problem.