I have an SSRS report that looks like this (with additional columns such as sales) with rows grouped by region and location.
The goal for the locations is the max for each location as in my query the goal appears on each sales record that I'm summing.
=Max(Fields!goal.Value)
The goal for the regions is the sum of the max for each location in that region group.
=Sum(max(Fields!goal.Value, "LocationName"), "region")
Those first two are no problem, but I'm having difficulty getting the grand total for the report which would be the sum of each region total.
=Sum(Fields!goal.Value, "region")
I can't reference the region group as the total is outside that group - "scope parameter that is not valid for an aggregate function". How do I get the sum of each region (7,000) in this instance?