When you create an Excel pivot table, the grand totals are automatically added at the bottom, and at the right. With the Grand Total command on the Excel Ribbon, you can show or hide the grand totals, but you can’t move them.
The good news is that there is a quick and easy workaround for this problem, which allows you to show the column grand total at the top.
There are written instructions on my Contextures website, on the Pivot Table Grand Totals page, where you can also download a sample file for this technique.
Watch the Grand Totals Video
To see the steps for the grand total workaround, please watch this short video.
__________________