I have a query that gives me the revenue each client generated by week.
Using the most current week. I need to know who has purchased previously. I know I am not giving much info but I am kind of brainstorming.
I need to know from the current week.
Percentage of New Clients
Percentage of Clients that have Purchases in the past 1 month, 2, 3 6 and 1 year.
Any suggestions? I was thinking about a crosstab query.
Using the most current week. I need to know who has purchased previously. I know I am not giving much info but I am kind of brainstorming.
I need to know from the current week.
Percentage of New Clients
Percentage of Clients that have Purchases in the past 1 month, 2, 3 6 and 1 year.
Any suggestions? I was thinking about a crosstab query.
