To change the default of showing grand totals for rows or columns:
1. Select a cell in the PivotTable report, right click and select Table Options -> Totals & Filters tab.
2. Clear the check box for Show grand totals for rows or Show grand totals for columns.
To show/hide grand totals:
Select PivotTable Tools Ribbon -> Design tab -> Grand Totals (in Layout Group).
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.