2 Replies Latest reply: Mar 30, 2015 11:11 AM by Piet Hein van der Stigchel RSS

    Conditional Formatting on a Pivot Table

      I attached a qvw where i created a pivot table showing the count of sales per employee for each business week.

       

      I want to color code the people to tell me who hasn't sold anything in 1 week, 2 weeks , 3 + weeks and then someone who has null/zeros for all weeks shown (never sold anything).  I need the conditional formula for the background to calculate from the most current week in the data.


      I don't care about which rgb codes at this time that are used.

       

       

      Any suggestions are greatly appreciated.

       

      Thanks,

      Robyn