8 Replies Latest reply: Jun 12, 2013 4:29 PM by Michael Solomovich RSS

    Column Background color in pivot table

    Logesh Jayaraman

      Hi ,

       

      I am trying to add the background color  in the pivot table based on the column value using the if else condition

       

       

      =

      If(Time='WTD',ARGB(255,132,189,0),
      If(Time='MTD',ARGB(199,132,189,0),
      ARGB

      (130,132,189,0)))

      it is working fine when it is at the column , but when it is dragged to a row it is not working.

       

      Is there any workaround or is it a bug?