I have transaction table like this:
How to create a report to calculate number of customers by products?
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.
I hv enclosed the sample.. KIndly advice
Please check the attached sample for solution.
This is fantastic, Jagan Mohan!
Retrieving data ...