Need some help with getting aggregate unique customers by customer type values

Slides

Registered User.
Local time
Today, 13:00
Joined
Jun 2, 2012
Messages
11
Here's what my table looks like:
MyTable
Unique_ID[FONT=&quot][/FONT]
Transaction_Type
[FONT=&quot][/FONT]
Customer_ID[FONT=&quot][/FONT]
1[FONT=&quot][/FONT]​
TypeA
[FONT=&quot][/FONT]
1
2[FONT=&quot][/FONT]​
TypeB 1
3[FONT=&quot][/FONT]​
TypeC
[FONT=&quot][/FONT]
2
4[FONT=&quot][/FONT]​
TypeD [FONT=&quot][/FONT]
3

Each row represents a transaction of some type. Each Customer_ID can be associated with multiple Transaction_Types. There are a set number of Transaction_Types (10).

How do I query the data to find out how many number of Transaction_Types unique customers had?

For example, the output would be:
Unique Customers Number of Transaction_Types 30,000 10 20,000 9 10,000 8 5,000 7 4,000 6 3,000 5 2,000 4 1,000 3 500 2 100 1
Beyond this, what would be the best way to find out which transaction types did customers have?

Unique Customers Number of TypeA Transaction_Types 30,000 10 20,000 9 10,000 8 5,000 7 4,000 6 3,000 5 2,000 4 1,000 3 500 2 100 1
Unique Customers Number of TypeB Transaction_Types 30,000 10 20,000 9 10,000 8 5,000 7 4,000 6 3,000 5 2,000 4 1,000 3 500 2 100 1

Is there a better way to show this information?

Thanks
 

Users who are viewing this thread

Back
Top Bottom