9 Replies Latest reply: Jun 7, 2013 8:21 AM by Jakub Szurogajlo RSS

    Background Color in Pivot table not always work.

    Jakub Szurogajlo

      Hello,

       

      I have a pivot table and Color Code column there which background should be same as text in the field...

       

      I have implemented it this way:

       

      =IF(ColorCode='Green',RGB(171,255,199),

      IF(ColorCode='Orange',RGB(255,231,132),

      IF(ColorCode='Red',RGB(255,186,165),

      IF(ColorCode='Blue',RGB(148,205,249),

      RGB(255,255,255)

      ))))

       

      But, strangely, there are fields which are not colored:

      (attached image)

       

      EDIT:

      I have now added qvw file for better explanation.

       

      Thanks for all advice!