I have gotten this far with my pivot table:
pivot table.png
I know need another subtotal added but I can not figure out how to do it! I need it to look like this:
Social Service
NAME
REG 5
Name Total 5
Name 2
OT 10
REG 30
Name 2 Total 40

REG 35
OT 10
Social Service Total 45