how to remove total in pivot table

"Strip Totals from PivotTable: Step-by-Step Guide"

By Joseph Lee
AD

When working with PivotTables, you might find that they include a 'Total' row by default, aggregating data from your source table. However, sometimes this 'Total' row isn't necessary, and removing it can enhance the readability of your PivotTable. Here's how to remove or hide the 'Total' row in your PivotTable.

Before starting, ensure your PivotTable is active. The steps we'll follow are compatible with Excel 365, 2019, 2016, and other versions.

Understanding the 'Total' Row in PivotTables

In PivotTables, the 'Total' row is generated to display the aggregated data (e.g., Sum, Average) of each column, providing a quick overview of your data. Although useful in many cases, it can also clutter your PivotTable if you're primarily interested in the individual data points.

AD
How to Remove Grand Total from Pivot Table (4 Quick Ways) - ExcelDemy
How to Remove Grand Total from Pivot Table (4 Quick Ways) - ExcelDemy
How to Remove Grand Total from a Pivot Table in Google Sheets
How to Remove Grand Total from a Pivot Table in Google Sheets
How to Remove Grand Total in a Pivot Table in Excel
How to Remove Grand Total in a Pivot Table in Excel

Let's delve into how to remove or hide this 'Total' row based on your specific needs.

Hiding the 'Total' Row

If you prefer to keep the total data accessible but hidden, you can choose to collapse the 'Total' row. This method is ideal when you want to make your PivotTable denser or focus solely on the individual data points.

How to Remove Grand Total from Pivot Table (4 Quick Ways) - ExcelDemy
How to Remove Grand Total from Pivot Table (4 Quick Ways) - ExcelDemy
How to Remove Grand Total from Pivot Table (4 Quick Ways) - ExcelDemy
How to Remove Grand Total from Pivot Table (4 Quick Ways) - ExcelDemy

To hide the 'Total' row:

  1. Select any cell in the 'Total' row.
  2. Right-click on the selected cell and choose 'Collapse Field' from the context menu.

Removing the 'Total' Row

If you're certain that you won't need the aggregated data, you can eliminate the 'Total' row altogether for a cleaner-looking PivotTable.

AD

To remove the 'Total' row:

  1. Select any cell in the 'Total' row.
  2. Right-click on the selected cell and choose 'Remove Field' or 'Remove' from the context menu.

Preventing the 'Total' Row from Reappearing

By default, your PivotTable might reintroduce the 'Total' row each time you refresh or modify it. To prevent this from happening, you can adjust a setting in the PivotTable Options.

To prevent the 'Total' row from reappearing:

AD
  1. Right-click anywhere in your PivotTable and choose 'PivotTable Options' or 'Options'.
  2. In the 'Layout & Format' tab, uncheck the box next to 'Add total at bottom of list' under the 'For fields' section.
  3. Click 'OK' to save your changes and close the 'PivotTable Options' dialog box.

Now that you've mastered removing or hiding the 'Total' row, you're better equipped to customize your PivotTables according to your specific needs. Keep exploring and refining your PivotTable skills for more insightful data analysis.

AD