top ten customers by transaction count by product

C

Carl

I have a data dump. each row represents a single transation for a product by
a customer. There are 15 products represented in the data dump. So product 1
could have 100+ transactions/rows by customer A. And custmer A could have
bought all 15 products in multiple transactions.

I would like to be able to display the top ten customers for each of my
product groups. Does this make sense?

An example fo the data:

Prod1 customer1 08/01/2001
Prod2 customer1 08/01/2001
Prod3 customer1 08/01/2001
Prod4 customer1 08/01/2001
Prod1 customer1 08/01/2001
Prod1 customer1 08/01/2001
Prod2 customer1 08/01/2001
Prod2 customer1 08/01/2001
Prod3 customer1 08/01/2001
Prod4 customer1 08/01/2001
Prod1 customer2 08/01/2001
Prod1 customer2 08/01/2001
Prod1 customer3 08/01/2001

So the report would look like this
Prod1 Cust1 3
Prod1 Cust2 2
Prod1 Cust3 1
Prod2 Cust1 3
Prod3 Cust1 2
Prod4 Cust1 2
 
J

JBoulton

I had a similar problem a while ago. Do a search for "top 25" and you'll
find a whole lot of help I received on this issue. I was able to completely
solve the issue with these comments.

HTH
 
C

Carl

Thanks!

JBoulton said:
I had a similar problem a while ago. Do a search for "top 25" and you'll
find a whole lot of help I received on this issue. I was able to completely
solve the issue with these comments.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top