title: RDLC Sum-Function for distinct values
body: <p>I have a specific question for my RDLC Report and a table, which data comes from a StoredProcedure. The looks like this:</p>
  
  <pre><code>Object  Price     More Data here...  
  ======  ========  =======
  X       10 $      ...  
  X       10 $      ...  
  Y       50 $      ... 
  Y       50 $      ... 
  Y       50 $      ... 
  Y       50 $      ... 
  Z       20 $      ...
  Z       20 $      ...
          Sum(expr)
  </code></pre>
  
  <p>What I now need is <strong>not</strong> the total Sum of those values, but the sum of all distinct values grouped by each object. So the result should be 80 $ (10+50+20)</p>
  
  <p>I have no specific row or column groups. Grouping after Object and adding a grouprow was not my solution, because the sum only has to be at the end of the table. And I didn't find out how to sum after group values...</p>
  
  <p>I tried different functions like Previous(compared the objects) and RunningValue(). But maybe I used them wrong or they showed me that this function can't be used in an Aggregate function. Maybe Maximun() for each Object is another idea, but it gave me the same error.</p>
  
  <p>Within my tunnelview I have now no idea anymore, what can help me with this case. So maybe one of you can help me.</p>
  
  <p>Thanks in advance</p>
  
  <p>// I am currently working with Visual Studio 2013</p>