I have created a matrix in SSRS 2008 (not R2) with two row groups which are Entity_Dept and CensusType. I also have a column group called MonthAbr and am summing on a field called CensusTotal. I don't want to change the order of my row groups but I want to sum by CensusType. There are three possible values for CensusType which are AdultOB, AdultNonOB and Newborn. So in the bottom of the matrix I want three rows of data that have the sum of these three. I have tried several different ways and the matrix always ends up totaling on Entity_Dept rather than CensusType. Can someone help? Thanks,Chuck W

Hi There Thanks for your posting. Can you please post some screenshot for your current output and Can you also please put something for your desired output. If I understand you correctly Entity_Dept a parent group of CensusType? And you would like to get the total based on CensusType regardless which Entity_Dept they belongs to, am I right? Please give some more details then someone might be able to help you out Many thanks Syed Qazafi Anjum

Hi Chuwil, The easiest way to get total is right click on your group and add total after, and please repeat this step for all groups and you will get the sum of these three groups. The screenshots below are for your reference: The report looks like: For more information about Adding Grouping and Totals, please see: http://msdn.microsoft.com/en-us/library/ms170712.aspx Regards, Charlie Liao