I've have a report in SSRS where i'am grouping on a column and showing its aggregate alongside it. The report will be in a format similar to below:
In the tablix, grouping is being done on State Column and sum of corresponding Population field is shown.
Now is there a way to access these SUM values outside the group, like i would like to access Population SUM of state abc, xyz and pqr individually. Is it possible, if so then how??