5 Replies Latest reply: May 23, 2014 9:59 AM by James Summerson RSS

    Colouring part of a pivot table expression

    Paul Nockolds

      I have the following expression in a pivot table chart

       

      If(Sum(RowsWithErrors)=0,Sum(RowsRead),Sum(RowsRead) & ' (' & Sum(RowsWithErrors) & ')')

       

      I would like if possible to colour the part in bold so it shows as red in the pivot table

       

      Any ideas?

       

      Message was edited by: Paul Nockolds  -  I've added the qvw in case anyone has any great ideas (see sheet 2)