I have 2 measures Sales & Cost.
I am then calculating Profit = Sales - Cost using a calculated field.
How can I show profit with back ground color RED if its < 0 and GREEN if > than 0
I am showing this data as text field.
I created another calculated field IF([Profit])> 0 then 'Green' ELSE 'Red' END. Later added this field on colors mark. But its not working correctly
Hope this helps.
Such a simple view, it required 100 steps!! - Having Multiple KPIs - - Still Struggling with Excel ?? <Tableau's Room>
It works, but you loose horizontal & vertical default sort capabilities on the measures.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...