top ten customers by transaction count by product
 

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

top ten customers by transaction count by product
 

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

"Carl" wrote:

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

top ten customers by transaction count by product
 

Thanks!

"JBoulton" wrote:

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

"Carl" wrote:

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