To find out who the biggest customer is for a product

[#1]

Hello,
I am wondering if anyone knows how to find out the biggest customer for a product is and display it by its name. And also to see how much the customer bought. This data will be used in a table.

Thanks!

[isaiah82]

Hi - you can use the FirstSortedValue function to return the customer in this case, using something like:

FirstSortedValue(Customer,-Aggr(Sum(Sales),Customer,Product))