SSRS Tablix - Each group as group header row

2
votes

I have a dataset looks like
enter image description here

Now I want to create a report where Dept as a group should be on row header for each group. looks like
enter image description here

I tried adding Dept as a parent group, but it appears on a column not as a header on top of each group.

reporting-servicesssrs-2012ssrs-tablix
Just add a total row, set the first column (above Age) to be Dept and then merge the cells across and format accordingly. - Alan Schofield
Thanks you Alan :) - Paul