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.




      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.