10 Replies Latest reply: Jun 20, 2011 12:15 PM by Dan Heller RSS

    Conditional color based on % to Total

    Dan Heller

      I am able to get the % to total values to display properly in my pivot table.  Now, I would like to display the following background color formatting as it is in Excel.  ([PS Department Group] and [KPI Month] (going across) are both dimensions.

       

      Red where the % for individual month is less than TOTAL % for all months.

      Green where the % for individual month is greater than TOTAL % for all months.

      Conditional Color.gif

      Any help is greatly appreciated!

      Thanks,

      Dan