title: Force a value of 0 for non-existing value
body: <p>Group, I am going to try and explain this as best I can, and I hope it makes (some) sense.  I am pulling data from a view I have created that tells me a "Sponsor's" customer types and how many of those accounts by CustomerType are inactive after 1 year, 2 years and 3 years.  For example:</p>
  
  <pre><code>SponsorID | CustomerType | ExpiredAfter | Total
  1234        D              1 Year         5
  1234        RA             1 Year         7
  1234        CA             1 Year         3
  1234        D              2 Years        2
  1234        RA             2 Years        4
  1234        CA             2 Years        1
  1234        D              3 Years        8
  1234        RA             3 Years        1
  1234        CA             3 Years        6
  </code></pre>
  
  <p>The problem I am having is a SponsorID might not have any RA that ExpiredAfter 1 year, so nothing shows up in the data.  So instead of getting:</p>
  
  <pre><code>SponsorID | CustomerType | ExpiredAfter | Total
  1235        D              1 Year         5
  1235        RA             1 Year         0
  1235        CA             1 Year         3
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>SponsorID | CustomerType | ExpiredAfter | Total
  1235        D              1 Year         5
  1235        CA             1 Year         3
  </code></pre>
  
  <p>Again, not sure if any of this makes any sense, but what I want to do is include all customer types for all ExpiredAfter regardless if there are values or not.  If there isn't a value I just want to force a 0 or Null.  I need that data row with 0 for reporting purposes.</p>
  
  <p>Any suggestions?</p>