Here's what my table looks like:
MyTable
TypeA
[FONT="][/FONT]
1
TypeB 1
TypeC
[FONT="][/FONT]
2
TypeD [FONT="][/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
MyTable
Unique_ID[FONT="][/FONT]
Transaction_Type
[FONT="][/FONT]
[FONT="][/FONT]
Customer_ID[FONT="][/FONT]
1[FONT="][/FONT]
[FONT="][/FONT]
1
2[FONT="][/FONT]
3[FONT="][/FONT]
[FONT="][/FONT]
2
4[FONT="][/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