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.
@Sergei Baklan 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!