I have a huge file with multiple rows per CustomerIDs and Dates.
There's a second field called PRODUCT which has various two digits text codes.
I want to accomplish two things
1) Convert the date to YYYY-MM
2) for all the combinations of CustomerID and YYYY-MM, I want to count the number of times each PRODUCT occurs.
Attached is a sample of 6-7 customers.
Thanks
Sample for Counting and SQL help.xlsx