Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
I hv enclosed the sample.. KIndly advice
Hi,
Please check the attached sample for solution.
Regards,
Jagan.
This is fantastic, Jagan Mohan!
Thanks!