title: SSRS Matrix Grand Total
body: <p>I have the followin matrix that shows a total per year, and I need to show the grand total across all years below that. Here is my current Matrix with the yearly totals:</p>
  
  <p><img src="https://i.stack.imgur.com/zbBIn.png" alt="enter image description here"></p>
  
  <p>I have the grand total stored in a variable but I'm struggling to get the formatting correct. </p>
  
  <p>The closest that I have got is to add the grand total as the first row. To do this I right click on the year column > Add Group > Group by x > Select Add Group Header > OK. Then delete the extra column that was added. </p>
  
  <p>It doesn't matter if I select add header or add footer, it always places the new row above the existing row. How do I put this total row at the bottom of the matrix? I need to have the total value span across all year columns and centered.</p>
  
  <p><img src="https://i.stack.imgur.com/8qwWm.png" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/KgkZr.png" alt="enter image description here"></p>