How to Remove Grand Total from Pivot Table in Google Sheets

Pivot tables in Google Sheets are fantastic for quickly summarizing vast amounts of data, but that automatic 'Grand Total' row they add isn’t always helpful. Sometimes it clutters your report, skews your charts, or simply isn't relevant to the analysis you're performing. This guide will walk you through the simple steps to remove the Grand Total from your pivot tables, giving you more control over your data presentation.

What Exactly is a Pivot Table?

Before we start removing pieces of it, let’s do a quick refresher. A pivot table is an interactive tool that takes a large, detailed dataset and reorganizes it into a concise summary or report. Imagine you have a spreadsheet with thousands of rows of sales data, listing every single transaction - product, region, sale amount, and date. A pivot table can instantly "pivot" that data to show you total sales per region, a breakdown of products sold per month, or the top-performing salesperson.

It works by letting you drag and drop fields from your source data into four main areas:

• Rows: This groups your data into rows. For example, using "Region" here would create a unique row for each region in your data.
• Columns: This groups your data into columns. Using "Year" here would create a column for each year.
• Values: This is the data you want to calculate. It's usually a number, like "Sale Amount," that you can sum up, average, or count.
• Filters: This lets you narrow down the data included in the pivot table, for instance, by showing only a specific product category.

By default, Google Sheets tries to be helpful by automatically adding totals for your rows and columns, culminating in a "Grand Total" that summarizes everything. But as we'll see, that helpful gesture can sometimes get in the way.

Why Would You Want to Remove the Grand Total?

Removing the grand total isn't just about personal preference, it often serves a practical analytical or visual purpose. Here are a few common situations where hiding the totals makes sense:

• Cleaner Charting: If you're creating a chart directly from your pivot table data, the grand total often creates a huge, outlier data point. For example, a bar chart of sales by employee will have one enormous "Grand Total" bar that shrinks all the others, making comparisons difficult. Removing it makes your visualization much clearer.
• Better Report Presentation: For some reports, your audience only needs to see the breakdown of the component parts. A grand total can distract from the main message or make the report feel cluttered. A clean, focused table is often more effective.
• Misleading Averages: This is a critical one. If your pivot table value is an average (like "Average Order Value"), the "Grand Total" will show you the average of the averages - not the true overall average. This is almost always a mathematically misleading and incorrect number that should be removed to avoid confusion.
• Easier Data Exporting: If you plan to copy and paste your pivot table's summary data into another sheet or application for further analysis, the total rows can get in the way and need to be manually deleted later. Removing them from the start saves a step.

Step-by-Step Guide: How to Remove Grand Totals in Google Sheets

Getting rid of those totals is incredibly straightforward. It all happens in the 'Pivot table editor'. Let’s walk through the exact steps with an example. Imagine a simple dataset of quarterly sales broken down by a few product categories.

Your pivot table might look something like this, with 'Product Category' as the row and 'Quarter' as the column, along with both row and column grand totals:

(Example image context: A simple pivot table showing categories like 'Widgets', 'Gadgets' on rows, and 'Q1', 'Q2' on columns, with a 'Grand Total' column on the right and a 'Grand Total' row at the bottom)

Here’s how to hide those totals.

Step 1: Open the Pivot Table Editor

First, click any cell inside your pivot table. This action is the trigger that makes the Pivot table editor sidebar appear on the right side of your Google Sheet. If you click outside the pivot table, the editor will disappear. So, if you don't see it, just click back on any part of the pivot table.

Step 2: Locate the Row and Column Fields

Inside the Pivot table editor, you'll see the fields you've added to the 'Rows' and 'Columns' sections. In our example, 'Product Category' is under 'Rows' and 'Quarter' is under 'Columns'. Each of these fields in the editor has options associated with it, including a checkbox labeled Show totals.

This is the key: this single checkbox controls whether a total is displayed for that specific field.

Step 3: Uncheck 'Show totals' to Remove Them

Now, you simply uncheck the box to remove the total you don't want.

• To remove the Grand Total row (at the bottom): In the 'Rows' section of the editor, find your outermost row field (in this case, 'Product Category') and uncheck the 'Show totals' checkbox next to it. The grand total row at the bottom of your table will instantly disappear.
• To remove the Grand Total column (on the right): In the 'Columns' section of the editor, find your column field (in this case, 'Quarter') and uncheck the 'Show totals' checkbox next to it. The grand total column will vanish.

You can remove one or both. If you want to get rid of all grand totals, simply uncheck the 'Show totals' box for both the row and column fields. It's really that simple!

Understanding Subtotals vs. Grand Totals

What if your table is more complex? Imagine you add another layer to your rows, like 'Salesperson,' nested under 'Product Category.' Now your pivot table will automatically generate subtotals for each product category in addition to the final grand total.

The same logic applies. The 'Show totals' checkbox works hierarchically:

• To remove the overall Grand Total: You uncheck 'Show totals' on the outermost field in the hierarchy ('Product Category' in this case).
• To remove only the subtotals: You can uncheck 'Show totals' on an inner field ('Salesperson'), which will remove the salesperson subtotals but keep the category subtotals and the final grand total.

This granular control allows you to customize your reports precisely. You can decide to show subtotals for major groupings while hiding the final grand total, or vice versa, giving you complete flexibility over the table’s layout.

A Practical Troubleshooting Tip

One common pitfall is forgetting which field controls which total. Just remember this simple rule:

The total appears for a field as a summary of the level inside it.

So, the total for the 'Product Category' row is a summary of all Salespeople within it. If there's nothing nested under 'Product Category' (it's the only field in the Rows section), its "total" becomes the final Grand Total. The same principle applies to columns. This logic helps you quickly identify which checkbox to uncheck.

Final Thoughts

Customizing your pivot table's display is a simple but powerful skill. By using the 'Show totals' checkboxes in the Pivot table editor, you can easily remove grand totals and subtotals, leading to cleaner charts, clearer reports, and more accurate presentations - especially when working with non-additive values like averages. It’s a small tweak that can have a big impact on a report's effectiveness.

While mastering spreadsheets for reporting is valuable, we know the process of manually preparing data, building pivot tables, and updating them weekly can feel repetitive. At Graphed , we automate all that tedious work. You just connect your data sources - like Google Analytics, Shopify, or your CRM - and use simple, natural language to ask for the dashboards and reports you need. Your reports are always live and update automatically, so you can spend less time wrangling spreadsheets and more time acting on insights.