Hi, I have two filed. One is customer id, the other is transaction numbers. Like this:
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
Take a look at the attached and see if this is what you are looking for