Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016

When you create a PivotTable that shows value amounts, subtotals and grand totals appear automatically, but you can also show or hide them.

PivotTable Grand Totals and Subtotals

Show or hide subtotals

  1. Click anywhere in the PivotTable to show the PivotTable Tools.

    PivotTable_Tools

  2. Click Design > Subtotals.

    PivotTable_Subtotals

  3. Pick the option you want:

    • Do Not Show Subtotals

    • Show all Subtotals at Bottom of Group

    • Show all Subtotals at Top of Group

      Tips: 

      • To include filtered items in the total amounts:

        • Click Include Filtered Items in Totals.

        • Click this option again to turn it off.

      • You’ll find additional options for totals and filtered items by following these steps:

        • Go in the PivotTable Options dialog box.

        • Select the Totals & Filters tab.

        • Click on Analyze, and then Options.

Show or hide grand totals

  1. Click anywhere in the PivotTable to show the PivotTable Tools on the ribbon.

    PivotTable Tools

  2. Click Design > Grand Totals.

PivotTable_GrandTotals

3. Pick the option you want:

  • Off for Rows and Columns

  • On for Rows and Columns

  • On for Rows only

  • On for Columns only

Tip: If you don’t want to show grand totals for rows or columns, uncheck the Show grand totals for rows or Show grand totals for columns boxes on the Totals & Filters tab in the PivotTable Options dialog box (Analyze> Options).

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

See Also

Create a PivotTable to analyze worksheet data

Create a PivotTable to analyze external data

Create a PivotTable to analyze data in multiple tables

Filter data in a PivotTable

Calculate a percentage for subtotals in a PivotTable

Sum values in a PivotTable

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.