9 Replies Latest reply: Mar 27, 2015 9:50 AM by Avinash Kuraku RSS

    Finding Max value

    Josh Duenyas

      Hi all

       

      How do I find which order has the max value?

       

      OrderNoAmount
      ABC125
      BCD325
      ABC541
      DEF125
      DEF135
      ABC438
      BCD223
      EFG123

       

      The dimension is against a SalesPerson

       

      I thought that Max(Sum(aggr(Amount,OredrNo))) will do but it does not.

       

      Thanks in advance

       

      Josh