Took a slightly different path on the workflow to match the end state (understood about the need to include 'customer segment' as a field selected for the Unique field; if data was different, might not get the desired output).
Regarding the multiple records for Customer ID 787, is there a way to add together the annual transactions using a tool or formula?