0 Replies Latest reply: Jun 30, 2013 9:33 PM by Jim Gay RSS

    Compare dimension total to row total

    Jim Gay

      Hi, I want to compare the dimension total for each 'manager' to each employee to set the background color of the cell.  If the employee is better than or equal to the average, i want to shade the cell green, otherwise shade the cell red.  I know this is a simple task but I cannot figure it out.

       

      Here is an example of what I hope to accomplish:

      qvw.jpg

       

      Any ideas?

       

      Thanks!