Show Grand Total at Top of Pivot Table

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.