Hi,
I have a data table that shows customer number, customer name, month of purchase, date of purchase, purchase amount, etc. For each customer, I'm trying to find the date the client first purchased from us. I have the data in a simple table as well as a pivot table with month along the horizontal axis, customer number on the vertical axis and purchase value in the body of the table. What is the best way to identify the month and year the client first purchased from us.
Thanks in advance
I have a data table that shows customer number, customer name, month of purchase, date of purchase, purchase amount, etc. For each customer, I'm trying to find the date the client first purchased from us. I have the data in a simple table as well as a pivot table with month along the horizontal axis, customer number on the vertical axis and purchase value in the body of the table. What is the best way to identify the month and year the client first purchased from us.
Thanks in advance