title: Crystal Report will not sum the duplicated record
body: <p>I'm working in Crystal Report 2008, And I have a data with like this:</p>
  
  <pre><code>  Date             KG         MT         SQM
   --------------------------------------------
  01-01-2013       25000        25         
  01-01-2013       15000        15
  01-01-2013       15000        15            -----(duplicated)
  01-02-2013       13000        13  
  01-02-2013       12000        12  
  01-03-2013       18000        18 
  01-03-2013       33000        33
  </code></pre>
  
  <p>Then I tried to group it by date so the output is like this: so it's already removed the duplicated and sum the vlaue without a problem.</p>
  
  <pre><code>  Date             KG         MT         SQM
   --------------------------------------------
   01-01-2013       40000        40        55000 
   01-02-2013       25000        25        25000
   01-03-2013       51000        51        51000 
  
   TOTAL            116,000      116      131,000
  </code></pre>
  
  <p>Then I want to add the SQM, and when I sum it, it will sum all the record in the group also with duplicated record. 
  (if you will sum the 3rd field, it also included in sum the duplicated record should be only '116,000' and not '131,000')</p>
  
  <p>My question, how can I suppressed if duplicated and at the same time it will give me summary of the group to show the correct value?</p>
  
  <p>Thanks,</p>
  
  <p>Captain16</p>