a left join will not magically create a July, you must have an order in July. You could start with the table FiscalPer thats assuming you have 12 periods, for us it wouldn’t work. Maybe Company Calendar or some other table that has Months, otherwise you will have to build one with FOR XML.
Idea 1:
Idea 2:
Idea 3:
MonthlySales from Epicor Demo Database
