title: Exclude Filtered data from Group Totals in Report Builder
body: <p>I have a stored procedure pulling data based on a parameter based "list date" range and rolling it up by month.   My output gives me rows based on the month. I need to filter out the "Previous" values which actually represent 'To Date'</p>
  
  <p>Month-------# Listed--------$ Listed</p>
  
  <p>Previous---------125--------1,000.00</p>
  
  <p>January-----------25-----------100.00</p>
  
  <p>February----------50-----------500.00</p>
  
  <p>To Date----------200---------1,600.00</p>
  
  <p>I can easily use a Group filter or even a Tablix filter to eliminate the detail row for the 'Previous' entries.  </p>
  
  <p>Month-------# Listed--------$ Listed</p>
  
  <p>January-----------25-----------100.00</p>
  
  <p>February----------50-----------500.00</p>
  
  <p>To Date----------200---------1,600.00</p>
  
  <p>However, I cannot find a way to exclude the filtered detail from the Group totals.    What I need to see is:</p>
  
  <p>Month-------# Listed--------$ Listed</p>
  
  <p>January-----------25-----------100.00</p>
  
  <p>February----------50-----------500.00</p>
  
  <p>To Date-----------75-----------600.00</p>
  
  <p>I don't have the option of modifying the stored procedure.  Any thoughts on how I can do this in Report Builder?  </p>