Client | When became a client | How long been a client | % |
ABC | 09/03/2017 | 1 year 10 months | |
DEF | 30/04/2013 | 5 years 9 months | |
GHI | 13/11/2007 | 11 years 2 months | |
JKL | 30/08/2018 | 0 years 5 months |
<tbody>
</tbody>
I am trying to work out the following:
I have a database of Clients and I have how long they have been a client of the business. I want to work out percentages based on:
% of clients who have been with the business less than one year, between 1 to 5 years, between 5 to 10 years and finally over 10 years.
There are 3345 active clients. So I would want to know the total % for each of the above criteria - if that makes sense?
Any ideas?
Many thanks
Lesley
Last edited: