title: SSRS 2008 Dataset Filtering - SUM / Break down by month
body: <p>I have a dataset that is going to get passed to an SSRS report that looks like this: </p>
  
  <pre><code>CODE TEXT COUNT  MONTH 
  100  ABC  20     January 
  100  ABC  10     February
  200  DEF  15     January 
  200  DEF  15     February
  300  GHI  0      x 
  400  JKL  10     January
  </code></pre>
  
  <p>This 'x' indicates there is no data for that code/text for the current year, however, I still need it to display. In SSRS I want to have a column to display for the current month (February) and a column to display for year to date:</p>
  
  <pre><code>    CODE TEXT MONTH_TO_DATE YEAR_TO_DATE
      100  ABC  10            30   [20 + 10]
      200  DEF  15            30   [15 + 15]
      300  GHI  0             0    [0] 
      400  JKL  0             10   [0 + 10] 
  </code></pre>
  
  <p>Is this possible in SSRS 2008? </p>