title: SSRS SUM() a grouped value outside of group
body: <p>I have a dynamically driven grouping, in this case group of values based on 3 items of their net and qty given a dynamic date range, grouped by month. I would like to get the total Net &amp; QTY for each row, as I already have a group total by column.</p>
  <p>So under [Total Quantity], I would like to get the sum of the result under Net which is already a value of [Sum(Net)]. I have used the following code: <code>=Sum(ReportItems!Textbox15.Value)</code> to only get the error:</p>
  <blockquote>
  <p>The Value expression for the textrun
  'Textbox8.Paragraphs[0].TextRuns[0]' uses an aggregate function on a
  report item.  Aggregate functions can be used only on report items
  contained in page headers and footers.</p>
  </blockquote>
  <p>What would be a better way to get these results?</p>
  <p><a href="https://i.stack.imgur.com/snFaJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/snFaJ.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/RrjoW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RrjoW.png" alt="enter image description here" /></a></p>