5 Replies Latest reply: Jul 12, 2016 10:44 PM by BAIKANG CHEN RSS

    Pivot Table - Dimension colour formatting

      I'm currently trying to colour a dimension on a pivot table as below.

       

       

      SourceMonthValue
      AOct

      0

      Nov2
      Dec2

       

      I want to have the source turn red when the value per source exceeds 3, however because the value is split by month the colour is not applying.

       

      Thanks in advance.

       

      CJ