Unique Customer Name and total spent

user08775

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

 

 

 

AS

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.