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

       

      Regards,

      Sooraj