Forum Discussion
Pivot tables - column grand total no longer available
A few days ago I right clicked on a pivot table's column header and selected to remove the column grand total... now Excel behaves as if I permanently deleted the option. I could use assistance with figuring out how to add it back.
If I go into the Pivot Table Options, the column grand total is checked off, and if I click on the Pivot Table Design tab, the Grand Totals for both rows and columns has been turned on, yet the column will not reappear. This happens will any spreadsheet, so it is not spreadsheet specific.
Any recommendations would be greatly appreciated!
5 Replies
Are Mailing City and Mailing Country column names in your source? In such case it shall be no Grand Total for rows since Pivot Table calculates totals based on fields.
If you drag any column into Columns part of right pane, grand total shall appear.
SergeiBaklan sorry, I should have provided more screenshots. It happens if the variables are listed under Columns. I tried everything I know but nothing worked. BUT it just hit me that I haven't rebooted my laptop in a few days, so I tried that, and the issue is gone. Smh, knowing it is Windows, a reboot should have been one of the first things I tried! Thanks for trying to help!
jstanford , okay, great to know
