如何在按多个字段分组时获得0总和？

I have tried looking and found using left outer joins tends to be the answer, but that usually is for a sum to a date grouping and not 2 levels of groupings. I think the additional grouping is messing me up.I have tried looking and found using left outer