• Rather than filtering the data at SP level, or Tablix, filter the Row Group. Add the Totals row to your tablix first, then in your Row Groups Pane put the filter on the Details_Group. The Total will still have the full total for the data that was returned to the report, where as the tablix will only display those you filtered to.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk