0 Replies Latest reply: Apr 17, 2012 6:03 AM by Martin Haynes RSS

    Pivot table label background colour

      HI

       

      Im trying to keep the label background colour to white on my expression on a pivot table.

       

      Im using the following code to set the colour (in the expression) of the cells but this also changes the colour of the label too.

       

       

      if(((column(3)- column(4))<= -0.10),rgb(199,255,193),

      if(((column(3)- column(4))> -0.10 and (column(3)- column(4))<=0),rgb(0,127,0),

      if(((column(3)- column(4))>0 and (column(3)- column(4))<=0.049),rgb(215,180,40),

      if((column(3)- column(4))>=0.05,rgb(255,0,0)

       

      ))))

       

      I dont this i can use visual cubes as this will only set 3 colours.

       

      Thanks

       

      Martin