Get the order count for Product and Basket in a table

[paddychanhk]

Hi Gurus,

I have a table that contains orders and items, and I want to create basket analysis tables using the attached Excel.

I tried this expression to get the Product and MBProduct count, but it only returns values if I select both Product and MBProduct:

Aggr(Count({1}DISTINCT
If(not Match(Product, MBProduct), Id)), Product)

I would like to have the result with the list of 5 columns and a list of all the product combinations with selection anything.

Product	MBProduct	Together	Only Product	Only MBProduct
Butter	Milk	2	7	4
Butter	Cookies	4	7	5
Butter	Fruit	3	7	7

Thanks.