I have tried about a million different ways to write the code to have my macro automatically set the pivot table subtotals to the bottom. It seems like it would be easy, but it isn't!
Here is what i get when i record the macro:
Sub SubTotalLocation_Bottom()
'
' SubTotalLocation_Bottom Macro
'...