title: How to aggregate details in Pentaho Report Designer (PRD) 3.9?
body: <p>Very new to Pentaho Reporting,</p>
  
  <p>I have a query grabbing columns <code>categories</code>, <code>quantity</code>, and <code>gross</code>.  It returns about 200 rows.  </p>
  
  <p>Without changing the query, is there a way for the report to display the aggregates for each category (I have category as a group)? For example, <code>All you can eat</code> should only display a sum of the <code>Amount</code> and <code>GrossValue</code> columns.   </p>
  
  <h2>Same for <code>dessert</code> (notice there are two group headers - why?)</h2>
  
  <p><img src="https://i.imgur.com/Y5AZMdY.jpg" alt="image"></p>