I have a retail sales database with the below information:
I need to find out
how much are the new customers in 2017 and 2018?
How much are the repeat customers in 2018 from the list of new customers in 2017?
How much are the repeat customers in 2018 overall?
Please share your data.
pls. find attached data in excel.
Do you want to achieve at back end (script) or front end?
Can you provide few lines of sample data to work?
Can you also provide output you are looking for in Excel?
This will make our job easy to help.
Output is simple.
it should show the new customer count and repeat customer count.
Retrieving data ...