title: How to sum SSRS Matrix Columns on Row Group
body: <p>I have a report that displays the total hours a person worked for each project they are assigned to, aggregated on month. I would like to sum the total hours for each person, for each month, in SSRS 2008 R2. So, for example, I have the follow data and would like to column totals like so:</p>
  
  <pre><code>                    January          February          March
  Worker 1
      Project1           50               80               20
      Project2           30               10               60
      Project3           10               40                5
             Total:      90              130               80
  Worker 2
      Project1           20               40               60
      Project2           10               30               10
      Porject3           30               10               50
             Total:      60               80              120
  </code></pre>
  
  <p>Everything I have tried so far either sums each column for all workers combined (summing by 'Month' column group) or sums all hours for each worker (Summing by 'Person' row group). </p>
  
  <p>For completeness, my row groups are:</p>
  
  <pre><code>Person
    Project
      RowGroup
  </code></pre>
  
  <p>My Column groups are:</p>
  
  <pre><code>Month
    ColumnGroup
  </code></pre>
  
  <p>I know that I can create another query/data set to do this, but I was hoping that SSRS can do this fairly easily. It seems like a trivial problem and perhaps I am just missing something.</p>
  
  <p>Any help would be great or perhaps this is something that SSRS can't do.</p>