Internal join the transaction table with the outcome from Move 2, then you'll have the total data of your transaction table with only Every customer's hottest record. +----+-------------+--------------------+------------+-------+-------------------------------------------------+-------------------------------------------------+---------+-------------------------------+----------+-----... https://billy295haq3.wikifordummies.com/user