So customer ordered:
Order 1: Item X and Item Y
Order 2: Item Y and Item Z
I’m not sure Michel, will your aggregation
- count the 3 unique items X, Y, Z which it should
- or 2+2=4 as the number of items per order?
Thats why I think, there is a group needed to have disinct items of all orders of one customer to get the result Sai is looking for.