How to add grand total to a pivot table in Microsoft Excel

Grand total is a feature in pivot tables that displays the total sum of values across all rows and columns. It provides a comprehensive summary of all the data in the pivot table. The grand total row and column are typically located at the bottom and rightmost part of the table, respectively. It allows users to quickly assess the overall picture of the data, identify trends, and make data-driven decisions.

In this tutorial, we will learn how to add grand total to a pivot table in Microsoft Excel. In Excel, there are several methods to add grand total to a pivot table. One method is to use the PivotTable Option to add the Grand Total row and column. Another method is to use the Design tab of the PivotTable Tools ribbon to add the Grand Total. Additionally, users can right-click on a pivot table and select the “Add Totals” option to add Grand Total to their pivot table.

Method 1: Adding Grand Total using the Design Tab

Step 1 – Click Anywhere on the Pivot Table and Go to The Design Tab

• Click anywhere inside the pivot table.
• The Design tab will be activated.
• Go to the Design Tab.

Step 2 – Click on the Grand Total Button

• Click on the Grand Total button in the Layout Section.
• A drop-down menu will appear.

Step 3 – Choose any of the Grand Total Options

• Choose the required Grand Total option i.e. “On for Rows Only”,  “On for Columns Only” or “On for Rows and Columns”.
• The Grand Total will be added.

Method 2: Using the PivotTable Options

Step 1 – Click Anywhere on the Pivot Table and Go to the PivotTable Analyze Tab

• Click anywhere on the pivot table.
• The PivotTable Analyze tab will be activated.
• Go to the PivotTable Analyze tab.

Step 2 – Locate and Click on the Options Button

• Locate and click on the Options button in the PivotTable section on the left of the ribbon.
• The PivotTable options dialog box will appear.

Step 3 – Go to the Totals & Filter Tab

• Go to the Totals & Filter tab.

Step 4 – Select the Grand Total Option

• Select the required Grand Total option in the Grand Totals section.

Step 5 – Click on OK 

• Click on OK in the PivotTable Options dialog box.

Method 3: Using the Context Menu to add Grand Total

Step 1 –  Right-Click on the Pivot Table

• Right-click on the Pivot Table.
• A context menu will appear.

Step 2 – Click on PivotTable Options

• Click on PivotTable Options in the context menu.
• The PivotTable options dialog box will appear.

Step 3 – Go to the Totals & Filter Tab

• Go to the Totals & Filter tab.

Step 4 – Select the Grand Total Option

• Select the required Grand Total option in the Grand Totals section.

Step 5 – Click on OK 

• Click on OK in the PivotTable Options dialog box.