Hi all! I'm conducting an analysis on spending. I'm trying to find how much individual customers have spent every month in the last year. I'm working with transaction data so we only have rows for transactions that actually happened. Therefore, for customer A who only transacted in January, February, and April, I want that customer to have rows that say "$0" for March, May, June, etc. so that I can get 12 rows of months of data for that customer rather than just 3.
Please let me know if you need any clarifying questions! I've tried approaching this with left joins, insertions, etc. but haven't had any fruition.
Please let me know if you need any clarifying questions! I've tried approaching this with left joins, insertions, etc. but haven't had any fruition.