Totals in Views

A SharePoint Online tutorial by Peter Kalmström

SharePoint iconIn this article about SharePoint views, Peter Kalmström, CEO and Systems Designer of Business Solutions, shows how the Totals feature can be used to summarize the numbers of a column.
The SharePoint Total can also show other values, like average, maximum and minimum, and you can also use it to count the number of items in a column.
SharePoint Totals

Unfortunately the Totals view can only be used in lists with the classic interface, but it will hopefully soon be added to modern lists also.

Enable the Totals feature for a column

  1. Create a new view or modify an existing view.
  2. Scroll down to Totals and click on the plus sign.
  3. Select the value you want to calculate from the dropdown to the right of the column that should have the Totals.
  4. Click OK

In the demo below Peter shows how you can use the Totals feature to count employees in each department. He creates a grouped view that shows the totals per department and then edits the page to show these totals in a web part.

Follow on LinkedInFacebook or Twitter!

back icon next icon
Products Buy FAQ Services Tips Books Contact About Us Tools

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved