Last transaction per order

Hi All,   I've got the following dataset    I'm trying to figure out a way of getting a list of order numbers where the last actcod (based on trndte) was 'CANPCK'.   Any help would be muc...