3 Replies Latest reply: Jan 20, 2013 7:09 AM by Deepak Vadithala RSS

    Getting sum of latest amounts recorded per ID

      Hi,

       

      with the below data set I need to get the sum of stock, for the latest datetime per ID

       

      IDDatetimeTransactionStock
      12012/01/01150500
      12012/01/16900600
      12012/06/30-400300
      22012/01/01700250
      22012/08/01600300

       

       

      so the sum of stock for this data would 600, however if I selected January as the datetime month I would want to see 850.

       

      Thanks in advance.

       

      Chris