6 Replies Latest reply: Feb 8, 2012 10:28 AM by Stefan Wühl RSS

    Color background color based on column partial sum

      Using pivot tables, how do I do the following.

       

      Capture.JPG

       

      So, I want to color code the row depending on how it's % Sold is doing compared to the total average (partial sum)

       

      So, for example, Cat Treat and Pig Leash have only sold 20% and 2% respectively while the overall average is 50% for all products, so it gets red.

       

      So, I know I need something like this for my background colors........

       

      if(total for column 3 >= column 3 for item, RED, BLUE)

       

      Thank you so much.