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

    Calculated Text Color changes to black in Report

    Lauren Lee

      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:


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