6 Replies Latest reply on Jan 19, 2018 3:44 PM by Tam Nguyen

    Conditional color based on color result of first column

    Tam Nguyen

      Hello Tableau Forum,

       

      I've a question on how to conditionally color values in columns based on color result of first column.

       

      In Profit Ratio worksheet below, the color for first column (2013) is red for profit ratio < 0%, orange for between 0% and 25%, and blue for > 25%.

       

      Question: how to change color for profit ratio in 2014, 2015, and 2016 to be the same as those in 2013? 

       

      That is, for Alabama, profit ratio for 2013 is orange, then for 2014, 2015, and 2016, the profit ratio should also be orange.

       

      For Arizona, profit ratio for 2013 is red, so for 2014, 2015, and 2016, profit ratio should all be red.

       

      profit ratio.png

      Please see attached workbook for details.  Thank you!