7 Replies Latest reply: Jun 18, 2014 10:31 AM by Lauren Lee RSS

    Calculated Text Color changes to black in Report

      I have a pivot table where the text colour is calculated depending on its value...the background colour is also calculated.

       

      When the table is put into a report, all of the text is black but the background colours are transferred across.

       

      This is the effect I am after:

      QV.bmp

      The 1's and the 5's that are white here (as they should be)...are black in the report.

       

      Any ideas?  I've been through all the settings I can think of....