I need to create a new table to see only the maximum purchase group by customer with the date of that purchase.
I have the correct grouping by customer, and simply chose MAX on the purchase which is great. I see the customer number with the customers maximum purchase. However, I want a third field, "year" that shows me the date of that purchase. If I choose group by then I will still have every purchase.
I want
Customer | Their Largest Purchase | Date of that Purchase