Pivot Table Grand Total at the top

Question

We have an Excel spreadsheet with the Grand Totals at the top using a Forumla, but this isn't on the actual Pivot Table it's just in the spreadsheet.

We have a client that wants the Grand Totals at the top of the Pivot Table and doesn't want us to use Formula. Does anyone know if this is possible (even using VBA or something, just so long as we don't look for a specific column or row name and compare with it (so no GETPIVOTDATA("Grand Total...)))?

Answer 1

I'd be happy to be proved wrong, but I don't think it's possible. I think you may have to do a little work on managing your client's expectations...

Answer 2

This slightly hacky solution might help:

http://www.contextures.com/xlPivot13.html