title: Compute sum for distinct order numbers in ssrs report
body: <p>I'm using a SQL Server 2008R2 Database and SSRS Report Builder 3.0
  Trying to compute the sum of the amount owed for each order id (need to show the itemids)...but when I do, the amount owed is showing 400 (instead of 200 - line 4, 100 instead of 50 in line 7, line 9 is correct. As a result the Total line is way off)</p>
  
  <pre><code>=Sum(Fields!owe.Value)
  </code></pre>
  
  <p>The report is grouped by the campus.
  I understand that ssrs is probably not the best place to do this computation but I don't know how to do outside of ssrs....I tried distinct and group by so far with no results.
  Below is how I need the report to show like....
  Thanks in advance.</p>
  
  <p><img src="https://i.stack.imgur.com/USl6s.jpg" alt="This is how I need the report to show"></p>
  
  <p>Incorrect amounts are
  <img src="https://i.stack.imgur.com/w7oeM.jpg" alt="enter image description here"></p>
  
  <p>Another example as it should display the subtotals
  <img src="https://i.stack.imgur.com/dJkNI.jpg" alt="enter image description here"></p>