[Fixed!] Pivot Table Grand Total Column Not Showing (6 Solutions)

PivotTable grand total column not showing

In a Pivot Table, we can get the Grand Total both row-wise and column-wise. However, the Grand Total column sometimes doesn’t show in the Pivot Table. In this article, we will show you six solutions to fix the issue Pivot Table grand total column not showing. If you are also curious about it, download our practice workbook and follow us.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


6 Possible Solutions If Pivot Table Grand Total Column Is Not Showing in Excel

To demonstrate the solutions, we consider a dataset of employees’ detailed information of any organization. Our dataset is in the range of cells B5:F14.

After converting the dataset into a Pivot Table we get the following fields for our dataset.

PivotTable fields to get the Grand Total column


Solution 1: Insert Proper Field in Columns Label

To get the Grand Total column, we have to input a suitable field in the Columns area. If we don’t have any field in the Columns area, the Grand Total column will not appear. We are also facing a similar type of problem in our Pivot Table.

The steps to fix the problem are shown below:

📌 Steps:

  • First of all, check the dataset to decide which field we can input in the Columns area. We have two fields: type of Home and Gender of the employee. We will input the Home type field in the Columns area,
  • Now, select the Home field and drag the field into the Columns area.
  • You will notice within a second that the Pivot Table shows the Grand Total column in column E.

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

Thus, we can say that our procedure works perfectly, and we are able to fix the problem Pivot Table grand total column not showing.

Read More: How to Add Grand Total to Stacked Column Pivot Chart


Solution 2: Modify Grand Total Drop-Down Options

Sometimes, the Grand Total column doesn’t show even if we input a suitable field in the Columns area.

The steps to fix the issue are given as follows:

📌 Steps:

  • First, go to the Design tab.
  • After that, from the Layout group, click on the drop-down arrow of the Grand Total option, and select the On for Rows and Columns option.

Choosing Right Grand Total Option to Display the Grand Total Column

  • The Grand Total column will appear in column E.

PivotTable grand total column not showing

So, we can say that our method works precisely, and we are able to fix the problem Pivot Table grand total column not showing.

Read More: How to Show Grand Total in Pivot Table (3 Easy Methods)


Solution 3: Check Features in Pivot Table Options Dialog Box

In this example, we will enable some features in the Pivot Table Options. Our Pivot Table doesn’t show the Grand Total column though we input a suitable field in the Columns area.

The steps to this approach are given below:

📌 Steps:

  • At first, in the Pivot Table Analyze tab, select the Options from the Pivot Table group.

Opening PivotTable Options Dialog Box for showing the Grand Total Column

  • As a result, the PivotTable Options dialog box will appear.
  • After that, go to the Totals & Filters tab.
  • Then, in the Grand Totals section, check the Show grand totals for rows option.
  • Finally, click OK.

Modifying Feature inside the Dialog Box for Our Desired Column

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

PivotTable grand total column not showing

Hence, we can say that our approach works effectively, and we are able to fix the problem Pivot Table grand total column not showing.

Read More: How to Make Subtotal and Grand Total in Excel (4 Methods)


Solution 4: Eliminate Existing Errors from Main Dataset

The presence of errors (like #DIV/0!, #Value, #N/A) in the main dataset also prevents the Grand Total column to show the grand total of our dataset. In our PivotTable, we are also facing a similar type of trouble. Our PivotTable doesn’t show the data properly.

The process to fix the issue is explained below:

📌 Steps:

  • At the beginning of the process, go back to the main dataset. We can see that we have two #DIV/0! Errors in our main dataset in the Income column.

Finding Errors in Main Dataset

  • Now, eliminate the errors from the dataset with necessary operations.

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

  • Then, in the Data tab, click on the Refresh All option from the Queries and Connections group.

Using Refresh All Commands to Update the PivotTable

  • The table will update.
  • However, if the PivotTable doesn’t update, then uncheck the Income field in the field list.

  • Then, drag the Income field again in the Value area.

Insert the Income Column to Update the Table

  • Finally, you will see the PivotTable will update and the grand total will show.

PivotTable grand total column not showing

Therefore, we can say that our approach works successfully, and we are able to fix the problem Pivot Table grand total column not showing.

Read More: How to Remove Grand Total from Pivot Table (4 Quick Ways)


Solution 5: Select Pivot Table Range Accurately

If the Pivot Table data range is not accurately selected, then you mat difficulties in getting the Grand Total. Its solving process is pretty straightforward.

First of all, select the entire columns of the Pivot Table and delete the table. Then, select the dataset accurately and make sure that no additional columns or rows are selected. Finally, insert the Pivot Table again, following the procedure of the last time.

We believe that following the procedure you will be able to correct your Pivot Table data range and will be able to fix the problem.


Solution 6: Ensure Data Consistency

Data consistency is another factor to get the grand total result properly. Sometimes, we mix two different columns in the Pivot Table. As a result, the result will not appear.

To fix this issue, select the entire column of the Pivot Table and delete the table. Then, insert the Pivot Table again and you will be able to fix the issue.


Conclusion

That’s the end of this article. I hope that this article will be helpful for you and you will be able to fix the problem Pivot Table grand total column not showing in Excel. Please share any further queries or recommendations with us in the comments section below if you have any other questions or suggestions.

Don’t forget to check our website, ExcelDemy, for several Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Soumik Dutta

Soumik Dutta

Hi! I am Soumik. I have completed my Bachelor of Science in Naval Architecture and Marine Engineering. I have found my calling in Machine Learning and Data Science, and in pursuing so, I have realized the importance of Data Analysis. Excel is one excellent tool to fulfill the purpose. I am always trying to learn every day about different features of Excel and trying to share here what I am learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo