Profit % is the measure.
You create a calculated field that looks like this:
IF sum(Profit%) < 0
ELSEIF sum(Profit%) > 0.1
--> Something like this
Put this calculated field on the Color mark and you have it?
Apologies, but I just changed the image where I've added two more columns. Now Profit % and Discount % both of these needs to be colored/highlighted based on the value which is common on the Legend. I need the bg of cell to be highlighted rather than its font.
Thanks for your time in sharing this work book. Am using Tableau 9.2.6 and looks like the workbook you've shared is from an higher version. Could you please share an down version compatible twb please?
I was on the same page, but somehow I wasn't able to expand more on the color part. Your solution paved way ahead