The Pivot Table Grand Total Column is Not Showing

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.

The Pivot Table Grand Total Column is Not Showing – 6 Solutions

Solution 1 – Insert a specific Field in the Columns Label

Solution 2 – Modify the Grand Total Drop-Down Options

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

Solution 4 – Eliminate Existing Errors in the Main Dataset

Solution 5 – Select the Pivot Table Range Accurately

Solution 6 – Ensure Data Consistency

Related Articles

Leave a reply Cancel reply