How to control grand totals in a pivot table

By default, a new pivot table includes Grand Totals for both rows and columns. But you can enable and disable Grand Totals for rows and columns independently.

Let’s take a look.

When you create a new pivot table, you’ll see Grand Totals displayed below the table and to the right of the table. Column Grand Totals appear in the last row of the table, and row Grand Totals appear in the last column of the table. However, depending on your needs, you may want to turn these on or off.

There are two ways to manage Grand Totals. The first way is to use the Design tab of the PivotTools ribbon. There you’ll find a dedicated menu for Grand Totals, that provides four options, in this order:

You can disable all Grand Totals.

You can enable Grand Totals for both rows and columns.

You can enable Grand Totals for just rows.

And finally, you can enable Grand Totals for just columns.

The other way to control Grand Totals is to use the PivotTable Options dialog box. You can reach this dialog using the Options menu, on the Options tab of the PivotTable Tools ribbon.

Once the dialog is open, navigate to the Totals & Filters tab. There, set Grand Totals as you like.

You can also reach pivot table options by right-clicking inside the pivot table and choosing PivotTable Options from the menu.