Avatar

Level 1

Hi Adobe Community!

 

I'm trying to get the product most ordered by a customer based on the below table:

oliviergroux_0-1601655881737.png

 

What I'm trying to achieve is to get a final table with Cus_ID | Most ordered 

Ex with the above:

Cus_ID             |  Most ordered 

677210000124 |  1,421

 

The main table is the Recipient table and the other table is linked via a "one to many" link.

What should I do to get to this outcome?

 

Thanks in advance,

Olivier