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


      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?