1 Reply Latest reply: Mar 11, 2011 5:14 PM by John Witherspoon RSS

    How to use visual effects sheet with expressionsn in pivot table???

      Hi,

      I have done a pivot table and i want to compare budget column with real column. If real column is higher, turn the value GREEN, if its the same, ORANGE, if its lower RED.

      The problem is that, as i think, it compares it with the total of the budget column and not with the value of region that i want.

      I attach the file so you can understand better what i reffer to.

       

      Pealse HELP!!!!!

       

      THANKS!!!!