title: Grouping SSRS column values that are similar
body: <p>This is a difficult question to articulate, but I'll give it my best:</p>
  
  <p>Basically my database has erroneous values and I want to write my SSRS to account for them rather than going in and cleaning up the DB.</p>
  
  <p>For simplicity's sake my records consist of 2 values: <strong>ownerid</strong> and <strong>case_type</strong>. Currently we have case_types that are lexicographically similar but conceptually identical. I want to create a report for records to account for these data inconsistencies. So...</p>
  
  <p>I would ideally like to turn a simple call center report like this:</p>
  
  <pre><code>Owner | Email | Inbound Phone | Inbound Phone Call
  bob   |  3    |     5         |     7
  jon   |  1    |     2         |     3
  </code></pre>
  
  <p>Where for each owner responded to x number of emails, y number of 'inbound phone' and z number of 'inbound phone calls'. (I didn't create this data and am the one dealing with it now).</p>
  
  <p>into:</p>
  
  <pre><code>Owner | Email | Inbound Phone Call
  bob   |  3    |     12
  jon   |  1    |     5
  </code></pre>
  
  <p>Essentially combining the count of 'inbound phone' and 'inbound phone call' records into a single column.</p>
  
  <p>PS This data is coming from CRM 2011 and I need to use Fetch as the query. I have all the records I need, I just need to figure out how to parse the bad ones.</p>