I'm trying to sort through a bunch of orders and get the customer name and the total spent for that customer. However, I have a customer name associated with each order. Meaning I can have 50 customer names. Same concept with the customer total spent. That information is totaled on each order row.
In short this is what I'm getting

I want only one unique row of:
UNFI - EAST 385,518.60
Can I do this in Beast Mode? I was having difficulty doing this in ETL
Thanks