7 Replies Latest reply: Jul 2, 2018 6:08 AM by Andrea Gigliotti RSS

    Color Expression.

    Agrim Sharma

      Hi All,

      in this Pivot table i want to get color condition, that if average rate of present month is lower than average rate of previous month then the value for present month's average rate should highlight in red color

      i used -

       

      IF(before(column(2))>(column(2)), RGB(201, 17, 62), green()) (for color expression)

       

      but its giving wrong output

      >my expression for average rate is -

      AVG({$<market={'DOMESTIC'}, [date.Calendar.Year]={'2018'},im_descr-={'*SCRAP*'}, im_descr_limited_flag = {1} >}rate)

      Capture.PNG