4 Replies Latest reply on Feb 25, 2016 2:21 PM by nicky.crooks

    Table calculations and colour dependent on value

    nicky.crooks

      Hi,

      I have a text table which lists customers down the left had column and had a date field at the top, filtered to only include Mondays.  The measure is 'volume of data' so the table shows the volume of data for each customer on each Monday.

       

      I need to know the percentage increase of the volume of data week on week so I have created a Table Calculation to show the percentage difference between the current and previous week and added this to the table.

       

      All good so far :-)

       

      However, I know want to colour code the Table calculation percentage difference fields so that growth of over 10% is red, reduction of over 10% is green and everything else is black.

       

      Please can you tell me how I can do this?  I have created IF statements previously on colour, but cannot see how I can do this for the Table calculation.

       

      Many thanks.