Forum Discussion
Conditional formating in a matrix using measures
Hi community, I need your help again.
I created a measure to use it in a matrix:
Then, I created the matrix using the values I got in my table "Opportunities": status, Current stage, and the measure as value:
and the result is this which was the expected:
Now I need to add some formatting using background color, font color, or icons, but the problem is the formatting does not take the whole result, but only one, and I suppose that is because the measure throws one result listed as different rows.
Is there a way to make this possible? I tried creating another measure and applying the format but did not work. Any ideas?
Thank you!!
2 Replies
- mcantosHelper II
Oh yeah, sorry I forgot the most important!! :S
The formatting should be applied based on a different file in the same table Opportunities "owner-email" but not included in the measure I'm displaying as values:
For instance
if owner-email="antoine" font color: Pink
if owner-email="zaks" font color: Red
if owner-email="xavier" font color: Blue
Thanks!