I'd like to be able to change the background color of the Total value’s in Percent column based on a formula. Expected results are shown in the below image of excel sheet. If I place the calculated filed on color, entire table is updated. Color is depend on +/- 10 from Exp sales value, for Green or Red.
Attached the sample workbook. Looking for your valuable suggestions.
Tableau doesn't work like excel.
Tableau is going to handle all the measures in a MeasureName/MeasureValue construct uniformly.
I walked someone through a technique to separate out separate column formatting in this thread. It's the same thing you're going to need to do: