6 Replies Latest reply: Nov 27, 2012 8:14 AM by Mahan Tesh RSS

    Aggr

      Hi all.

       

      I have this table:

       

      ID, Product, Name, Amount

      001, B, AA, 150

      001, B, BB, 130

      002, B, CC, 170

      002, B, DD, 190

       

      and i want obtain this output:

       

      ID, Product, Name, max(Amount)

      001, B, AA, 150

      002, B, CC, 170

       

      I try to use in a table

      dimension: ID, Product, Name

      and expression: only(aggr(max(Amount), ID, Product, Name)

      but not works.

       

      Someone can help me?

       

       

      Regards,

      Marco