I am using QV ver 11. I have a list of sales transactions with the associated dates and customer IDs. What I require to know is the number of new or returning customers. That is defined as anyone who has bought from us for the first time since the last 90 days.
So for example I want to know the new or returning customers for Dec 29 2012. I need a count of the customer IDs who shopped on Dec 29 and who did not shop between Sep 30 and Dec 28. I did this manually by selecting the date range Sep 30 - Dec 28. Then I selected the excluded Customer IDs. Then I selected Dec 29th. I have a chart where I counted the distinct customer IDs and it generated the number I am looking for. Lets say that number is 10. I can do the same sort of excerise for Dec 30 and lets say that gets me 12 new or returning customers. I need to get 22 new or returning customers for the period Dec 29/30.
