Thank you, but I figured out just after I posted the question.
It turns out all I had to do was put a copy of the matrix with out the Office group displayed in an added row above the office group total
If you would like more information on my solution let me know.
Help with subtotals
I have a report in SSRS 2008 set up as a Matrix currently pulling in a years worth of hours data set up like:
Office1
Emp1
HoursType1
HoursType2
Emp2
HoursType1
HoursType2
HoursType3
HoursType4
Emp3
HoursType1
HoursType2
Total HoursType1
Total...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.