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!
