2 Replies Latest reply: Oct 2, 2011 1:23 PM by Jean-Jacques Jesua RSS

    Aggr / Set Analysis Problem

    Matan Chalamish

      Hi All.

       

      Please look at the atached qvw.

       

      I want to take the UnitPrice  of the highest Ord, group by Key.

      i.e: to the Key = pal-320346 I want to show: 34.2

      Key = pal-323111 I want to shoe: 11.2

       

       

      My expression is:  Sum ({< Ord = {'=(Aggr(Max(Ord),Key))'} >}(UnitPrice) )

      The QV take the UnitPrice from the first loaded row.

       

      How can i do that?

       

      Many Thanks -
      Matan.