I am running this version, in case it matters.
Microsoft SQL Server Reporting Services Version 11.0.6251.0
I will describe my data using a simple example. Let's say my dataset returns 3 rows.
I create a table and link it to this dataset. And I add a total at the bottom... very simple. When I run the report, it shows the 3 rows and a total row that has the sum of the numbers associated with each row.
Next, I want to filter the data, WITHOUT editing the SQL in the dataset. So I add a filter on the "Details"... I am talking about the thing that appears under Row Groups section of the report designer. There, I right click and create a filter to filter out one of the 3 rows.
When I run this report, I see the row filtered out correctly (so now I see only 2 rows), but the total still shows the total for all 3 rows.
How do I get the total to be the total of the filtered detail?