SSRS Report- Not getting correct Grand total.

If the total is the dataset total and you only want to have the total for the values showing in the report. Then I assume you are hiding some of the rows from the dataset in the report. Then you have to adjust the formula for the sum to exclude those records as well. Something like:

=Sum(iif(Fields!Headend.Value="Sidney", Fields!UniqueSubCounts.Value,0))

Select allOpen in new window

This will sum the UniqueSubCounts field only for the rows where Headend is Sidney.

Maybe instead of hiding rows from the recordset you can exclude the rows in the query, or use a filter on the dataset. That way these rows will not be included in the total.

But it's difficult for me to answer this question without any information about the design of the report. If my suggestion doesn't help you fixing the problem. Please provide more information about the design of the report.

Thanks Nicobo,

There are no hidden rows in the table .  The subcounts are only at Lineup Level but cliented wanted additional fields to be added which is causing duplicate subcounts since they have relationship with them.

Now they want to see all the data but show the total for Unique subcounts. The formula you provided makes sense, but I believe instead of headend I will try Lineup .