Help with grouping and Subtotals of subtotals

[jaygerwolf]

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 HoursType2
Total HoursType3
Total HoursType4
Total Hours for office1

Office2
Emp4
HoursType1
HoursType2
HoursType3
HoursType4
Emp5
HoursType1
HoursType2
HoursType3
HoursType4
Emp6
HoursType1
HoursType2
Total HoursType1
Total HoursType2
Total HoursType3
Total HoursType4
Total Hours for office2

I can get the total for each of the offices but seem to be struggling with getting the subtotals of the hour types.

My table is set up (Office, Emp, HoursType, Hours)
Matrix groups on (Office, Emp, HoursType)

I have been searching, but seem to only find tips and help on the single subtotal. I figure this has to be something silly that I am just missing.

Any thoughts or suggestions would be very helpful.
Thank you

 

[jaygerwolf]

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.