I have a date table and a table that shows customers, start date and cancel date. I want to do a by month bar chart that shows a count of customers that started in the month and cancelled in the month.
How do I limit my count to each month for the start date and cancel date. I understand how to do this if I was counting by start month only, but I a confused how I would count a customer as a START in say April and then that same customer as a CANCEL in July when both the START and CANCEL date are on the same row of data for that customer.
I appreciate any assistance you can offer.