1 Reply Latest reply: Oct 24, 2012 1:40 PM by mayilvahanan ramasamy RSS

    display most recent event

    mary lin
      i'm trying to select the most recent event based on a date for each customer.
      dataset:
      customereventdate
      1sign1/2/12
      1
      apply1/3/12
      1accept1/5/12
      1renew1/7/12
      2sign2/7/12
      2apply2/3/12
      2accept3/12/12
      2deny1/4/12
      3apply2/1/12
      3renew3/12/12
      result:
      customereventdate
      1renew1/7/12
      2accept3/12/12
      3renew3/12/12

       

       

      however, if i select an event (i.e. sign), i want to see the 'signs' so i don't want to eliminate the other values, just display the most recent if no events are selected.

       

      thanks!