Unique Customer Name and total spent

user08775
user08775
in Dataflows

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

 

Thanks

 

 

 

Comments

  • AS
    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.

    Aaron
    MajorDomo @ Merit Medical

    **Say "Thanks" by clicking the heart in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories