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

[#1]

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!!!!

[johnw]

I never use visual cues. Instead, on the expressions tab, click on the + next to Tarifa, click on "text color", and then enter this expression:

if(round(Tarifa,.01)>round(sum([BDG Tarifa]),.01),green()
,if(round(Tarifa,.01)<round(sum([BDG Tarifa]),.01),lightred()
,rgb(248,180,39)))

Works fine.