SharePoint Document Issues

How to Restore Missing Overall Totals in Grouped SharePoint List Views

Ayan Masood Sep 28, 2026 869 views

Question details

The overall total count for all items in a grouped SharePoint list view is missing, even though individual group totals are displayed.

How to Restore Missing Overall Totals in Grouped SharePoint List Views

Product: SharePoint
Device & OS: not provided
Scenario: Viewing a grouped list after a formatting or view update.
Observed behavior: The SharePoint list shows totals for individual groups but fails to display the grand total for all items combined.

Before you start

Ensure you have the necessary Edit permissions for the SharePoint list so you can create, modify, and save new views.

Solution 1Recommended

Recreate the SharePoint List View

Creating a new view with identical settings is the most effective way to restore the missing overall totals.

Sometimes list views in SharePoint become corrupted after organization-wide updates or formatting changes. Rebuilding the view from scratch clears these invisible errors.

Note current settings

Navigate to your SharePoint list and take note of the current grouping, totals, sorting, and filtering settings used in the broken view.

Create a new view

Click on the View selector dropdown menu in the top right corner of the list and select 'Create new view' or 'Save view as'.

Apply identical settings

Name your new view, then configure it with the exact same settings you noted earlier, ensuring the 'Totals' option is properly checked for the columns you want to sum.

Save and verify

Save the new view. The overall total should now display correctly at the top or bottom of your grouped list.

Set as Default: Once verified, you can set this new view as the default for your team and safely delete the old, corrupted view.

Solution 2

Check for Formatting Conflicts

Custom JSON formatting might be overriding or hiding the grand total row.

Free Microsoft Office alternative

Boost Your Productivity with WPS Office

While SharePoint lists are excellent for online tracking, complex data often requires a dedicated spreadsheet tool. WPS Office is a lightweight, free alternative to Microsoft Office that easily handles large datasets, complex groupings, and grand totals offline.

1. Export List Data: Export your SharePoint list to a CSV or Excel file directly from your browser.
2. Open in WPS Spreadsheet: Launch WPS Office and open the exported file to access your data.
3. Calculate Totals Easily: Use the Data menu's Subtotal feature to instantly generate accurate group and grand totals.

Free and lightweight office suite for Windows, Mac, and LinuxFully compatible with Microsoft Excel (.xlsx) and CSV formatsFamiliar user interface makes data management intuitiveAdvanced PivotTables and Subtotal features for effortless data analysis

microsoft office alternative - wps office

Frequently Asked Questions

Why did the overall total disappear from my SharePoint list?

The grand total often disappears due to corrupted view settings, backend formatting conflicts following a SharePoint update, or custom JSON code applied to the list.

Can I recover the old view instead of recreating it?

If a backend update corrupted the view, there is no direct rollback option. Recreating the view using your original settings is the fastest and most reliable fix.

Do I need admin rights to fix the list view totals?

You need 'Edit' permissions on the SharePoint list to create and save new public views. If you only have 'Read' access, you can create a personal view to see the totals.

Document & File Issues