If I have a total of 400 unique clients in January and it grows to 800 unique clients in October, how can I get a count of how many distinct clients were added for each month?
Ex.
Jan - 400
Feb - 43
Mar - 61
Apr - 31
May - 55
Jun - 49
Jul - 65
Aug - 33
Sep - 30
Oct - 33
800 total
My data set starts in January and I will add to it at the end of each month. It is a list of services and dates, so a client can have multiple services in different months.
Thank you!!
Solved! Go to Solution.
Genius! Not sure how I deciphered your answer (being a relative noob), but I did and it worked!
Thank you so much.
User | Count |
---|---|
18 | |
14 | |
13 | |
9 | |
8 |