Recently I have seen some threads where people have been asking for Partial Sum's / Sub Totals in a straight table.
Immediate first thought was Why Oh Why! we have a Pivot table to do just that! But there are a couple of benefits I liked when creating the solution.
What I liked:
1) Custom Labels for Subtotal , as you can see above
2) Clicking on the Subtotal Collapses the inner dimensions, YAY! Whereas the same with a Pivot table will be a two step process that is Right Click >> Collapse All