Reporting a Hierarchy with totals at the bottom? (upside down tree?)

[AndyC]

I have successfully created a Hierarchy Pivot table but my problem is that i want the sub totals for each level to be at the bottom of each group and not at the top.

i.e.

Anyone got any ideas?