5 Replies Latest reply on Sep 18, 2018 2:17 AM by sooraj j

    Row wise conditional formatting

    sooraj j

      Hi Friends,


      Please see the attached the screenshot. I would like to color each products and then need to show each product wise high value and minimum value on row wise.


      I used the calculation like this :


      if ( [AUM per Branch])=WINDOW_MAX( [AUM per Branch]) then 1 else if ([AUM per Branch])=WINDOW_MIN([AUM per Branch]) then 1 else 0 end end

      and this calculation into color legend.


      How to achieve this?


      Please suggest your comments , Thanks in advance