Hi,
I am trying to do the following:
Please consider this scenario. One table has list of all customers, and another table has all the purchase made by this customers. The two tables are linked by customer id.
Now, I need to present a report listing the most recent purchases of the customers in this format.
Last 30 days-
list of all customers whose last purchase was in this time frame.
Last 30-60 days
List of all customers whose last purchase was in this time frame.
etc...
I need to list only one record per customer( which is the most recent purchase).
How can I do this? I am having difficulty in getting the report to display only the latest purchase. It lists all the purchases done.
Thank you
Ravi
I am trying to do the following:
Please consider this scenario. One table has list of all customers, and another table has all the purchase made by this customers. The two tables are linked by customer id.
Now, I need to present a report listing the most recent purchases of the customers in this format.
Last 30 days-
list of all customers whose last purchase was in this time frame.
Last 30-60 days
List of all customers whose last purchase was in this time frame.
etc...
I need to list only one record per customer( which is the most recent purchase).
How can I do this? I am having difficulty in getting the report to display only the latest purchase. It lists all the purchases done.
Thank you
Ravi