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)