Hello Everyone,
I have a crosstab with my measures like below. Set1 has been defined with one measure(say measure1) from one source and set2 has been defined with another measure(say measure2) from another source. Blending involved in Tableau to get this report.
I need measure2 to be highlighted in the report from this condition by comparing from each month. If (measure2 - Measure 1) >= 5 then 'Green' Else 'Red' end
YTD has been defined by taking average of the 3 months. And i want those values also to be highlighted for set2 when Measure2 YTD > Measure1 YTD.
I tried the ways what i know but didn't worked for me.
Can anyone please help me on this..
2 answers