title: SSRS - Group Columns Together
body: <p>All:</p>
  
  <p>I have the following data (see Raw Data attachment). Inside my SSRS Report, I have a column for "Name / Stream / Offer One / Offer Two" (Name is the column for the "Value" column shown in the image).</p>
  
  <p>I need my SSRS Report to display one row of the "totals" for each Name.  Then under this, I need a row for each Stream associated with the Name that displays the values for that stream.  </p>
  
  <p>For the SSRS Output (please see second screen shot).  The data loads into my tablix, but I need one row for "BAG-CV" that displays the total for that Name.  Then under this row, I need a row for "AR" stream with the data for.  </p>
  
  <p>If you see Name: JAC-FL, it has 5 streams listed under it.  So I would need one row for the total of JAC-FL, then 5 rows under it listing all the streams associated with this name.  </p>
  
  <p>Hopefully this makes sense.  </p>
  
  <p><a href="https://i.stack.imgur.com/LTf72.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LTf72.jpg" alt="Raw Data"></a></p>
  
  <p><a href="https://i.stack.imgur.com/DczNH.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DczNH.jpg" alt="Report Output"></a></p>