title: SSRS - Suppression and column total on duplicates
body: <p>I have a report where I need to suppress columns of text when they are dupicate (done) but also total two columns of figures (net debit &amp; credit) leaving the other two columns (ccy &amp; ccy amount) itemised as they are.</p>
  
  <p>When dealing with data like:</p>
  
  <pre><code>DESCRIPTION                  DEBIT        CREDIT     CCY    CCY AMOUNT
  332300 Creditors              0.00          0.50     EUR         -0.50
  339003 Sundry Creditors       0.00      4,423.39     EUR     -4,423.39
  339003 Sundry Creditors   4,241.50          0.00     GBP      3,587.50
  340101 Ordinary Shares        0.00          1.41     GBP         -1.00
  395000 Revenue Reserves       0.00    196,850.46     EUR   -196,850.46
  395000 Revenue Reserves       0.00    967,816.68     GBP   -797,995.90
  </code></pre>
  
  <p>I have managed to surpress the description when duplicated but would like to only display the appropriate net debit or credit amount just leaving the ccy and amount itemised, like this:</p>
  
  <pre><code>DESCRIPTION                  DEBIT        CREDIT      CCY    CCY AMOUNT
  332300 Creditors                            0.50      EUR         -0.50
  339003 Sundry Creditors                   181.89      EUR     -4,423.39
                                                        GBP      3,587.50
  340101 Ordinary Shares                      1.41      GBP         -1.00
  395000 Revenue Reserves             1,164,667.14      EUR  - 196,850.46
                                                        GBP   -797,995.90
  </code></pre>
  
  <p>Any help solving or assisting with this problem would be very much appreciated.</p>