Oct 02 2019 10:39 AM
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!
Oct 02 2019 11:15 AM
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.
Oct 02 2019 02:42 PM
@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!
Oct 02 2019 02:48 PM
@jstanford , okay, great to know
Nov 08 2019 10:40 AM
@Sergei Baklan Hello! I just encountered the same issue but with rows not totaling anymore. I shut down my laptop yesterday when this happened but the issue still there today when I started up. Any ideas?
Nov 08 2019 11:58 AM
Power Pivot adds totals for rows if as columns you have values of one field. Here you have two separated fields, REVENUE AMT and FREIGHT AMT.
You may add total as Calculated field, let name it Total and expression will be =REVENUE AMT+FREIGHT AMT.
Or use similar measure if you added your data to data model.