title: Including a value once in a summed SSRS group
body: <p>I have a data source which is pulling in event attendance information which looks like the following table.</p>
  
  <p>Note that one booking can contain multiple attendees, causing duplication in the <code>Amount</code> column.</p>
  
  <pre><code>+------------+-----------+---------------+----------+
  | Date       | Booking   | Booking Price | Attendee |
  +------------+-----------+---------------+----------+
  | 01/01/2011 | Booking 1 |       £300.00 | Alice    |
  | 01/01/2011 | Booking 1 |       £300.00 | Bob      |
  | 01/01/2011 | Booking 1 |       £300.00 | Dave     |
  | 01/01/2011 | Booking 2 |       £200.00 | Frank    |
  | 01/01/2011 | Booking 2 |       £200.00 | Julie    |
  | 02/01/2011 | Booking 3 |       £100.00 | Anne     |
  +------------+-----------+---------------+----------+
  </code></pre>
  
  <p>The Report <em>should</em> end up a bit like this:</p>
  
  <pre><code>+------------+-----------+---------+
  | Date       | Booking   | Amount  |
  +------------+-----------+---------+
  | 01/01/2011 | Booking 1 |    £300 |
  |            |    Alice  |         |
  |            |    Bob    |         |
  |            |    Dave   |         |
  +------------+-----------+---------+
  |            | Booking 2 |    £200 |
  |            |    Frank  |         |
  |            |    Julie  |         |
  +============+===========+=========+
  |   TOTAL FOR 01/01/2011 |    £500 |
  |                                  |
  |                                  |
  +============+===========+=========+
  | 02/01/2011 | Booking 3 |    £100 |
  |            |     Anne  |         |
  +============+===========+=========+
  |   TOTAL FOR 02/01/2011 |    £100 |
  |                                  |
  |                                  |
  +============+===========+=========+
  </code></pre>
  
  <p>(That pretty much exhausts my ascii-art table skills!)</p>
  
  <p>The problem I have is that because the <code>amount</code> is showing for each delegate, the aggregate functions count them all, so date for 01/01/2011 shows as £1300, instead of £500</p>
  
  <p>I don't need any values next to the attendees, so I could pull it in a separate data set, but I can't seem to add a table into a tablix cell, so don't know how that would work.</p>