By default, the last row of the pivot table displays column totals, and the last column displays row totals.
To hide or redisplay column totals, use one of the following methods:
•On the Options tab, in the Grand totals section, clear or select the For columns checkbox.
•Right-click any cell in the pivot table to open the context menu and select Show grand totals. In the sub-menu that opens, clear or select the For columns checkbox.
To hide or redisplay row totals, use one of the following methods:
•On the Options tab, in the Grand totals section, clear or select the For rows checkbox.
•Right-click any cell in the pivot table to open the context menu and select Show grand totals. In the sub-menu that opens, clear or select the For rows checkbox.