4 Replies Latest reply: May 18, 2016 4:30 AM by Chanty 4u RSS

    Color Coding Pivot Table

    Philip Radovich

      Hi,

       

      I am trying to color code the values of my pivot table based on the different dimensions in the column section. I have the AVG Value as the measure and I currently have this If (Avg(Value)>=1500, RGB(87,149,50), RGB(170,57,57)) for my background color expression but it highlights every single value instead of the specific one's I need in the column. Is there a way to set the color of each value different based on the parameters needed for the column?

       

      Thanks,

      Philip Radovich