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 kalmstrom.com 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

The Totals view can be used in lists with the classic as well as the modern interface. In the modern interface, the Totals figure is shown below the list of items.

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.





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

Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved