How to Remove Subtotals in Pivot Table Google Sheets

Pivot tables in Google Sheets are fantastic for summarizing large datasets, but the automatic subtotals they generate can sometimes get in the way. While helpful for a hierarchical overview, these extra rows can clutter your view when you just want to see the fine details or one final grand total. This guide will walk you through exactly how to remove those subtotals, giving you full control over your report's layout.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Remove Subtotals from a Pivot Table?

Before jumping into the "how," let's quickly cover the "why." You're not just being picky by wanting to remove subtotals, there are several practical reasons why a cleaner view is better:

• Improved Clarity: Sometimes, the intermediate totals are just noise. If your goal is to compare individual items against each other, subtotals can be a major distraction that breaks the flow of your data. Removing them allows you to focus on the raw line-item performance.
• Clean Data for Charting: If you plan to create a chart from your pivot table data, subtotals can ruin your visualization. A bar chart, for instance, might display a massive bar for the subtotal next to a tiny bar for an individual item, completely skewing the scale and making the chart difficult to read.
• Compact and Professional Reports: A report with fewer, more relevant rows looks cleaner and is easier to digest. When sharing with colleagues or clients, a streamlined pivot table that shows only the necessary information appears more professional and to the point.
• Easier Copy/Paste and Data Export: If you need to copy your pivot table summary into another document, email, or presentation, the subtotals add extra rows that you'll likely have to delete manually later. Removing them at the source saves you a tedious cleanup step down the line.

A Quick Look at Pivot Table Structure

To understand where subtotals come from, it helps to remember the basic building blocks of a pivot table. The Pivot table editor pane has four main areas:

• Rows: Fields you drag here will populate the rows of your table. This is where subtotals most commonly appear, especially when you use multiple row fields (e.g., Region, then Sales Rep).
• Columns: Fields placed here will create the columns of your table. Like rows, using multiple column fields can also generate subtotals.
• Values: This is for the numeric data you want to summarize, like 'Sales,' 'Revenue,' or 'Quantity.' The values are calculated for each row and column intersection.
• Filters: Allows you to limit the data displayed in the entire pivot table based on specific criteria.

Google Sheets automatically adds subtotals whenever you create a hierarchy in either the Rows or Columns sections - for example, placing 'Year' and then 'Month' into the Rows area. It assumes you want to see a total for each year in addition to the monthly breakdown. Our goal is to simply turn that assumption off.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step-by-Step Guide: How to Remove Subtotals in Google Sheets

Removing these subtotals is incredibly straightforward. It’s just a matter of unchecking a single box in the right place. Let's walk through it with a common example.

Imagine we have sales data and have created a pivot table with 'Product Category' and then 'Product' in the Rows section, and 'Sum of Revenue' in the Values section. By default, it will look something like this, with a subtotal for "Electronics."

(Example Table: Before)

Electronics Total: $12,500 &nbsp,&nbsp,&nbsp,&nbsp,Laptop: $8,000 &nbsp,&nbsp,&nbsp,&nbsp,Smartphone: $4,500 Clothing Total: $3,200 &nbsp,&nbsp,&nbsp,&nbsp,T-Shirt: $1,200 &nbsp,&nbsp,&nbsp,&nbsp,Jeans: $2,000 Grand Total: $15,700

Our objective is to get rid of the "Electronics Total" and "Clothing Total" rows, leaving only the individual products and the grand total.

Step 1: Open the Pivot Table Editor

If the Pivot table editor pane isn’t already visible on the right side of your screen, simply click on any cell inside your pivot table. The editor will automatically pop up.

Step 2: Find the Correct Field in the "Rows" Section

In the Pivot table editor, look at the Rows section. You will see the fields that are creating the rows in your table. In our example, we have two: 'Product Category' and 'Product'.

Subtotals are generated by the parent-level field in the hierarchy. In this case, 'Product Category' is the parent that is grouping the individual 'Product' items. Therefore, 'Product Category' is the field whose subtotals we need to disable.

Step 3: Uncheck the "Show totals" Box

This is the key step. Next to the 'Product Category' field in the Rows area of the editor, you will see a checkbox labeled "Show totals." It will be checked by default.

Click on this checkbox to uncheck it.

Instantly, you will see your pivot table update. The subtotal rows for "Electronics Total" and "Clothing Total" will disappear, leaving a much cleaner table.

(Example Table: After)

Electronics &nbsp,&nbsp,&nbsp,&nbsp,Laptop: $8,000 &nbsp,&nbsp,&nbsp,&nbsp,Smartphone: $4,500 Clothing &nbsp,&nbsp,&nbsp,&nbsp,T-Shirt: $1,200 &nbsp,&nbsp,&nbsp,&nbsp,Jeans: $2,000 Grand Total: $15,700

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Repeat for Other Fields or Columns if Needed

If you have multiple levels of nesting (e.g., 'Region', 'Country', 'City'), you will have a "Show totals" checkbox for each field. You can selectively disable subtotals for any level. For instance, you could remove the subtotals for 'Country' but keep them for 'Region' by unchecking the box for the 'Country' field only.

The same logic applies if you have nested fields in the Columns section. Just locate the column field in the editor and uncheck its corresponding "Show totals" box.

What About Grand Totals?

Unchecking the "Show totals" box for a specific field only removes the subtotals for that category. It does not affect the Grand Total at the bottom of your report.

If you want to remove the grand totals as well, there's a separate, dedicated option for that at the very bottom of the Pivot table editor. Under both the Row and Column headers in the editor, you'll find two more checkboxes, also labeled "Show totals."

• Unchecking Show totals under the list of Row fields removes the overall column grand total (the final sum at the bottom).
• Unchecking Show totals under the list of Column fields removes the overall row grand total (the final sum on the far right).

Common Troubleshooting Tips

The process is generally seamless, but here are a couple of situations you might run into and how to solve them.

"The subtotals are still there after I unchecked the box!"

This almost always happens when you uncheck the box for the wrong field. Remember, you need to uncheck "Show totals" for the parent field in the hierarchy, not the child field.

In our example, if you unchecked the box next to 'Product' instead of 'Product Category', nothing would change, because the 'Product' field isn't generating any subtotals itself. Go back to the Pivot table editor and make sure you've selected the correct field that is actually doing the grouping.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

"How do I get the subtotals back?"

This is simple! Just reverse the process. Go back to the Pivot table editor, find the field, and re-check the "Show totals" box. The subtotals will reappear instantly. This is a non-destructive toggle, so you can turn it on and off as often as you like without messing up your data.

"My pivot table layout collapsed."

By default, Google Sheets shows an indented, collapsible view for nested row items. When you remove the subtotals for a parent field, you also lose the little arrow that allows you to collapse and expand that group. The pivot table becomes a flatter list.

This is expected behavior. The 'grouping' is still there visually, but the interactive collapsing feature's parent - the subtotal row - has been removed. If you need that functionality back, you'll have to re-enable the subtotals.

Final Thoughts

Mastering the display of your Google Sheets pivot table is all about controlling the small details, and removing subtotals is an easy win for creating cleaner, more focused reports. By simply unchecking the "Show totals" box for the appropriate fields in the Pivot table editor, you can transform a cluttered summary into a sleek, presentation-ready analysis.

While tweaking pivot tables is a powerful skill, manually wrangling reports week after week can be time-consuming. At Graphed, we automate this entire process. You can connect data sources like Google Sheets, Shopify, or Google Analytics, and then use simple, natural language to build the exact dashboards you need. Instead of clicking through menus to remove subtotals, you can just ask, "Show me a list of sales per product for last quarter, with a grand total," and get a live, updating visual in seconds, freeing you up to act on the insights, not just look for them.