Using pivot table grand totals for a row is not showing in excel

Question

Grand total for a column is showing but not for rows using pivot table. Troubleshooting :have tested on a new machine , uninstall / reinstall office, Tested on web app same result , tested with a new file as well, it's a multiple user issue

Answer 1

Hi,

Here are some things you should check-

1. If you have filters or slicers connected to your pivot table, make sure they are not accidentally affecting the display of grand totals.
2. Try creating a dummy pivot table and try to replicate the issue. It can help you determine the problem.
3. Make sure your Excel is up to date.
4. Disable any third-party add-ins and check if the issue is resolved.
5. Test with a different user account on the same machine to see if the problem persists. This can help isolate whether the issue is user-specific or machine-specific.

Best Regards.