Customize the display of grand totals

By default, the last row of the pivot table displays column totals, and the last column displays row totals.

To hide or unhide column or row totals, use one of the following methods:

–On the Options tab, in the Grand totals section, select or clear the For columns / For rows checkbox.

–Right-click any cell in the pivot table to open the context menu and select Show grand totals. In the submenu that opens, select or clear the For columns / For rows checkbox.