In a pivot table, you can choose to show or hide the grand totals, but you can’t change their position. However, with a quick and easy workaround (no programming required), you can show the grand total for columns at the top of the pivot table.
Unfortunately, there’s nothing similar that will create a grand total for rows at the left side of the pivot table.
Read the Instructions
To see the written instructions, please visit the Contextures website, and go to the Pivot Table Grand Totals page. There is also a sample file on that page, that you can download.
Watch the Video
To see the steps for creating a grand total at the top of a pivot table, watch this short video.