title: Reporting services put data from two DataSet rows in one tablix cell
body: <p>I need to create report with table which looks like this</p>
  
  <pre>
               Country 1    Country 2    Country 3    Total
  Category 1     1(2)         2(1)         5(6)        8(9)
  Category 2     2(3)         2(1)         4(0)        8(4)
  Category 3     3(2)         2(1)         3(1)        8(4)
  Total          6(7)         6(3)         12(7)       24(17)
  </pre>
  
  <p>Report contains data about TFS WI's and has information about current week's WI count and last weeks WI count (in brackets)</p>
  
  <p>Data set on which this report is based on MDX query against TFS warehousw cube and has such structure:</p>
  
  <pre>
  Category    Country    Week   Count
     1           1       this     1  
     1           2       this     2
     1           3       this     5    
     1           1       last     2  
     1           2       last     1
     1           3       last     6    
  </pre>
  
  <p>Trouble is, I cann't find a way how to concatenate data about current and last weeks incident count in one cell. I have toyed around with idea to do it in MDX, but with my limited MDX skills I can't see how it could be done.</p>