title: Dynamically group by with "Group Header"
body: <p>Could someone help me with this problem. I have a table with Products, ProductsSales. Here are some screenshots of them.</p>
  
  <p><img src="https://i.stack.imgur.com/AGexl.png" alt="Product table"></p>
  
  <p><img src="https://i.stack.imgur.com/UXKhq.png" alt="Product sales table"></p>
  
  <p>Now I would like to make a TSQL query which can group them and add something like a "header description"?
  Something like this </p>
  
  <p><img src="https://i.stack.imgur.com/uCW1V.png" alt="Endproduct"></p>
  
  <p>It would be perfect, if it is a relatively dynamically query. </p>
  
  <p><strong>Could someone help me here or give me some tipps?</strong></p>