5 Replies Latest reply: Mar 8, 2013 3:32 AM by Roderick McKeown RSS

    Aggr max function

      Hi guys

       

      I am wating to find the max valueof sales for a particular company.

       

      Have tried this but not working.

       

       

      =if([Total Sales]=max(Aggr([Total Sales],[Company Name])),'Y', 'N')