2 Replies Latest reply on Mar 4, 2013 9:57 AM by James Martin

    How can I apply dynamic color based on a metric, but only have it color ONE of the columns on my table, not the whole thing?

    James Martin

      Hey everyone,

       

      Basically I have a table with a list of States down the X and 5 metrics across the Y.  I would like to have the color of the final metric (% change) dynamically change to red or green based on whether it is positive or negative.

       

      The issue I'm having is, when I apply this, the color changes for the entire table - I only want the color to change on the LAST column (the one with the metric that the color is based on).

       

      Is there a custom calculation that will allow this?  Or even a simpler solution.

       

      Thanks!!