Repeat customers for Products

[madhuqliklondon]

Hi all,

I am working on a task where I have to count items brought 2 times , 3 times and 4+ times.

For example :

date is like this

Item.No	Customer.No	Order.No
111	1	A123
122	1	A123
111	2	A222
111	2	A234
111	3	A345
122	3	A567
111	4	A989
111	4	A1234
111	4	A2345

Chart I would like to see is below:

Item.No	No of times purchased	count of customers
111	2	1
111	3	1

Thank you

[Anil_Babu_Samineni]

May be this?

Count({<[Customer.No] = {"=Count([Customer.No])>1"}>} [Customer.No])

[madhuqliklondon]

Hi Anil,

How to get the no.of times purchased ???

[madhuqliklondon]

Any ideas please??