Show MAX value of unique customers with respective item

[tushar44]

Hi there,

Problem: Show the most purchased item by each customer

Input:

Desired output:

Thanks!

[Kenda]

Hi @tushar44 

In this case, there are two options that come to mind.

One option would be to use a summarize tool first. You'll want to group by customer then take the max of the % field. Finally, you'll need a join tool to get back the item field. 

Another option would be to first use a sort tool to sort by customer then %. Next, use a sample tool take the 1st record, grouping by customer. 

Hope this helps!

[Emil_Kos]

Hi @tushar44,

Values are different but it should work for you.

Good luck!