Hi all:
I have one table with the following fields.
Customer ID
Customer First Name
Customer Last Name
Customer Transaction Number
Customer Transaction Volume
County
There are customers who do transactions in more than one county. In those cases we have multiple records for that customer. I would like to do the following:
1.) Get a list of the top 1000 customers by county sorted by transaction volume. This step is simple enough. However, the next step is what I am unable to figure out.
2.) If a customer has transactions in more than one county, then I want the customer appearing in only the county where he/she has the highest transaction volume. I do not want the customer appearing in the other counties' top 1000 lists even though he/she has transactions in those counties and might be in the top 1000 for that county.
I hope the question is clear. Is this possible? How can I do this. Thanks in advance for any help.
I have one table with the following fields.
Customer ID
Customer First Name
Customer Last Name
Customer Transaction Number
Customer Transaction Volume
County
There are customers who do transactions in more than one county. In those cases we have multiple records for that customer. I would like to do the following:
1.) Get a list of the top 1000 customers by county sorted by transaction volume. This step is simple enough. However, the next step is what I am unable to figure out.
2.) If a customer has transactions in more than one county, then I want the customer appearing in only the county where he/she has the highest transaction volume. I do not want the customer appearing in the other counties' top 1000 lists even though he/she has transactions in those counties and might be in the top 1000 for that county.
I hope the question is clear. Is this possible? How can I do this. Thanks in advance for any help.