5 Replies Latest reply: Dec 9, 2013 10:13 AM by Fabrice Aunez RSS

    aggr

    christian juillard

      Hi everybody

       

      I've a little aggr issue to solve

       

      Some people have 2 status. When there are different i can't display the last one.

       

      Ex :

      Name     Date          Status

      A             2/11/13       open

      A             2/12/13      stand by

      B            5/11/13        open

      B           2/12/13         open

       

      What i get is

      Name     Status

      A             -

      B          open

       

      and I'd like to get Status Stand by for A

      I tried to aggregate on max(date) but it didn't work

       

      Thank you for your help

      Chris