7 Replies Latest reply on Apr 4, 2012 3:54 PM by Andy Kriebel

    Is there a calculation for coloring cells based on the Measure Values field?

    Andy Kriebel

      In the table below, the brands are measures and the trade names are dimensions.  Ideally what I want to be able to do is color the cells based on the "measure values" field, but I'm struggling to figure out the formula.  I tried using parameters, but those will only color based on one of the measures.

       

      Basically I want to be the cells colored in the following manner:

       

      < 50 = Red

      50 to 60 = Blue

      60+ = Black

       

      Any ideas?

      Untitled.png

       

      P.S. I thought this thread was the same situation, but the directions don't help in my case.  http://community.tableau.com/thread/116439