Excel -- Pivot Tables -- Grand Totals

  1. Show Grand Total at Top

 

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 file

Create the fake "Grand Total" field

  1. In the source data, add a column with the heading GT, or use a space character as the column heading
  2. In every row of the source data, for the GT field, enter: Grand Total
  3. Add this field to the pivot table, as the first field in the Row area

 

Change the Field Settings

  1. In the pivot table, right-click on the GT field button, and click Field Settings
  2. Click the Layout button
  3. Click Show Items in Outline Form
  4. Add a check mark to Display Subtotals at Top of Group
  5. Click OK, twice.

 

Hide the original Grand Total

  1. Right-click on a cell in the Pivot Table
  2. Click Table Options
  3. Remove the check mark for Grand Totals for Columns
  4. Click OK

 

 
1. Pivot Tables -- Dynamic Data Source
2. Pivot Tables -- Data Field Layout
3. Pivot Tables -- Show and Hide Items
4. Pivot Tables -- Clear Old Items
5. Pivot Tables -- Field Settings
6. Pivot Tables -- GetPivotData
7. Pivot Tables -- Grouping Data
8. Pivot Tables -- Multiple Consolidation Ranges
9. Pivot Tables -- Printing   
10. Pivot Tables -- Custom Calculations 
11. Pivot Tables -- Pivot Cache      
12. Pivot Tables -- Protection  
13. Pivot Tables -- Grand Totals
 

       Home     Excel Tips     Excel Files      Blog    Contact

 

RSS Feed

 

 

 

The Excel Store

Last updated: July 18, 2008 11:53 PM