2 Replies Latest reply on Mar 24, 2013 9:10 PM by Ricardo Nunez

    How can I filter the last transaction ID?

    Ricardo Nunez

      I have a transaction log for shipments (Shipment ID). I need to analyze only the last transaction for all Shipment ID's and I am working with the MAX(itransactionID) and it does not seem to work. For example purposes I created he column "last transaction ID" as this is the end result that I am looking for to analyze my shipments.

       

      I am enclosing the packaged workbook and an image of what I need.

       

      Thanks

       

      Ricardo