Sign in to Community
Sign in to view all badges
Hi Adobe Community!
I'm trying to get the product most ordered by a customer based on the below table:
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,
Were you able to resolve this query with the given solution? Do let us know.