Last updated: July 18, 2008 11:53 PM
![]()
Excel -- Pivot Tables -- Grand Totals
Show Grand Total at the Top of a Pivot Table
There's no setting that allows you to display the grand total at the top of a pivot table. However, with this technique you can use another field that acts as the grand total, and display it at the top.Note: The instructions and sample file are for Excel 2003 and earlier.
Download the zipped sample fileCreate the fake "Grand Total" field
- In the source data, add a column with the heading GT, or use a space character as the column heading
- In every row of the source data, for the GT field, enter: Grand Total
- Add this field to the pivot table, as the first field in the Row area
Change the Field Settings
- In the pivot table, right-click on the GT field button, and click Field Settings
- Click the Layout button
- Click Show Items in Outline Form
- Add a check mark to Display Subtotals at Top of Group
- Click OK, twice.
Hide the original Grand Total