Can someone advise on how I can create a table which groups the data so it is one month for each row? I tried Group by and it just formats the date column fields to the month-year. But continues to track each individual date separately.
It's grouping based on all non-aggregated fields. Because you're not aggregating the NumberDelivered field it's including it in the grouping. If you aggregate it with Sum it should remove the duplicate SendDate fields and aggregate it for the entire month.