[URGENT] How to know which customer buy 2 products together?

[#1]

Hi,

I have transaction table like this:

Customer	Products	Qty
Cust A	MCD	1
Cust A	KFC	3
Cust B	MCD	6
Cust C	KFC	7
Cust D	MCD	9
Cust E	MCD	2

How to create a report to calculate number of customers by products?

Products	No of Customers
MCD	3
MCD & KFC	1
KFC	1

Thanks

[jagan]

Hi,

Create a straigth table with Customer as Dimension and the expression below

If(Count(DISTINCT Products) > 1, Count(DISTINCT Products), 0)

Now the table will displays only customers who has purchased multiple products.

Regards,

Jagan.

[#3]

I hv enclosed the sample.. KIndly advice

[jagan · Accepted solution]

Hi,

Please check the attached sample for solution.

Regards,

Jagan.

[#5]

This is fantastic, Jagan Mohan!

Thanks!