Unique Customer Name and total spent

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

Screen Shot 2017-12-15 at 8.45.51 AM.png


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







  • Depending on the other data you have in there, you should be able to get unique values by aggregating the total spent column. If for every customer that value is always the same, then you can use an avg, min, or max function to do that.