Pivot Table Grand Total Column is Not Showing – 6 Solutions

Pivot Table Grand Total Column is Not Showing – 6 Solutions

 

This is the sample dataset.

After converting the dataset into a Pivot Table, the following fields are displayed.

PivotTable fields to get the Grand Total column


Solution 1 – Insert a specific Field in the Columns Label

To get the Grand Total column, a specific field needs to be inserted in the Columns area.

 

Steps:

  • Decide which field to input in the Columns area. Here, Home.
  • Select the Home field and drag it into the Columns area.
  • The Pivot Table will display the Grand Total in column E.

Insert Proper Field in Columns Area to Fix PivotTable Grand Total Column Not Showing

 


Solution 2 – Modify the Grand Total Drop-Down Options

To Show the Grand Total in the Pivot Table:

Steps:

  • Go to the Design tab.
  • In Layout, click Grand Total.
  • Select On for Rows and Columns.

Choosing Right Grand Total Option to Display the Grand Total Column

  • The Grand Total column will be displayed in column E.

PivotTable grand total column not showing


Solution 4 – Check the Features in the Pivot Table Options Dialog Box

Steps:

  • In the Pivot Table Analyze tab, select Pivot Table.
  • Select Options.

Opening PivotTable Options Dialog Box for showing the Grand Total Column

  • In the PivotTable Options dialog box, go to Totals & Filters.
  • In Grand Totals , check Show grand totals for rows.
  • Click OK.

Modifying Feature inside the Dialog Box for Our Desired Column

  • You will see the Grand Total column in column E.

PivotTable grand total column not showing

 


Solution 4 – Eliminate Existing Errors in the Main Dataset

The presence of errors (like #DIV/0!, #Value, #N/A) in the main dataset prevents the Grand Total column from being displayed.

Steps:

  • Go to the main dataset. There are two #DIV/0! Errors in the Income column.

Finding Errors in Main Dataset

  • Eliminate the errors.

Eliminate Existing Errors from Main Dataset to Fix PivotTable Grand Total Column Not Showing

  • In the Data tab, click Refresh All in Queries and Connections.

Using Refresh All Commands to Update the PivotTable

  • The table will be updated.
  • If the PivotTable isn’t updated, uncheck Income.

  • Drag the Income field to the Value area.

Insert the Income Column to Update the Table

  • The PivotTable will display the grand total.

PivotTable grand total column not showing

 


Solution 5 – Select the Pivot Table Range Accurately

Select the entire columns in the Pivot Table and delete the table. Select the dataset accurately. Insert the Pivot Table again.


Solution 6 – Ensure Data Consistency

Select the entire column of the Pivot Table and delete the table. Insert the Pivot Table again.


Download Practice Workbook

Download the practice workbook.


Related Articles


<< Go Back to Pivot Table Calculations | Pivot Table in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Soumik Dutta
Soumik Dutta

Soumik Dutta, having earned a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, plays a key role as an Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Soumik not only skillfully addresses complex challenges but also demonstrates enthusiasm and expertise in gracefully navigating tough situations, underscoring his unwavering commitment to consistently deliver exceptional, high-quality content that... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo