title: Add additional total row after grouping in SQL
body: <p>I'm creating an SSRS report where I need to display the sum of values by a group, and I need to create master groupings for these groups. I'm wondering if this is possible. If not, is it possible to just add another row to sum a grouped query? </p>
  
  <p>My current code is as follows:</p>
  
  <pre><code>    SELECT ISNULL([MasterGroup],'Other') AS 'Receipts',
      SUM([ReceiptAmount]) AS 'Sum'
      FROM TableA
      WHERE [MasterGroup] IN ('Other','A','B','C','D','E')
      GROUP BY [MasterGroup]
  </code></pre>
  
  <p>Unfortunately, only A-E groups are showing, the NULL which was replaced as other is not showing too. </p>
  
  <p>What I'm currently seeing:</p>
  
  <p><img src="https://i.imgur.com/2f2pC56.png" alt="current query result"></p>
  
  <p>If possible, this is what I would like to output:</p>
  
  <p><img src="https://i.imgur.com/0NtRGMF.png" alt="what I would like to see"></p>
  
  <p>If I'm not able to do this in a single query, I can probably create multiple rows to reach my end goal and what I would like to output is this: </p>
  
  <p><img src="https://i.imgur.com/C6HTBfR.png" alt="If this is not possible, this is what I would like to output"></p>