title: SSRS - How to group Date into Today/Yesterday/Week/Month in a Matrix?
body: <p>I have data sorted by dates:</p>
  
  <p>e.g.
  Region - Date - Count<br/>
  East - 2012/01/01 - 5<br/>
  West - 2012/01/01 - 2<br/>
  East - 2012/01/06 - 3<br/>
  South - 2012/01/07 - 3<br/>
  etc</p>
  
  <p>I'm trying to create a sum of the Counts, grouped by date groups relative to today. So for example </p>
  
  <p>Assuming today was 2012/01/07:</p>
  
  <ul>
  <li>Yesterday is defined to be from Today - 1 to today (non-inclusive of
  today) </li>
  <li>Week is defined to be from Today - 7 to today  (non-inclusive    of
  today)  </li>
  <li>Month is defined to be from Today - 28 to today (non-inclusive
  of today)</li>
  </ul>
  
  <p>The output in the matrix for the sample data would be:</p>
  
  <p><img src="https://i.stack.imgur.com/LFOlS.png" alt="enter image description here"></p>
  
  <p>As a bonus, ideally I'd have a 5th column that's for "On Demand" Start and End date range for the user to input.</p>
  
  <p>I think the key is to add an EXPR in the Column Group's Group On property but I don't know what the Expression should be.</p>
  
  <p>Any help would be great!</p>