Multiple Transactions Date and Status - Obtaining the last one
I am trying to obtain the last transaction from an customer decision based on the last decision date and therefore obtain the last decision status. However when I add the fields of the decision status it brings duplicate transactions from the same customer, bings all the transaction description along with the corresponding date/time.
Decision Status Decision Date/Time
Record 12345 - Denied May 1, 2009
Condition May 2, 2009
Approved May 3, 2009
In this case I only want the customer 1235 - Approved - May 3, 2009