Show Grand Total at Top of Pivot Table

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 at top of  pivot table, for rhe pivot table columns.

Here’s a screen shot with a Grand Total at the top of a pivot table. It was created with this workaround.

grandtotaltop01

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.

__________________