Skip to main content

Hi, I have two filed. One is customer id, the other is transaction numbers. Like this:

customer type about different number of transactions

Now I want to calculate how many customers and how percentage are:

1. customer without transaction

2. customer with only one transaction

3. customer with repeat transactions

 

How can I do that?

Thank you!

15 answers
0/9000