2 Replies Latest reply: Oct 6, 2014 6:57 AM by Herbert Chitate RSS

    First Sorted Value

      Hi All,

       

      I have data, say for example the following fields:

       

      Client ID

      Date of Purchase (This is a time stamp with also hour, mins and seconds)

      Category

      Store

      Region

       

      A client can have multiple purchases on the same day , i.e. repeated client ID on a date, but I would like extract a list of the customer's last purchase using First Sorted Value. Can someone help me on what the code would look like.

       

      Thanks

       

      H