SharePoint Office Pocket Guide

Adding Totals, Groupings, and Filters

As you enter items in the Expenses list, you may want to view the data in certain ways. For example, you may want a running total on what you've spent, or you may want to see what you spent on Epoxy. The list can both include totals and filter or group items in various ways.

There are two ways to view totals in a list. The first way, which is described in the following steps, is the easiest and most effective:

1. Choose "Edit in Datasheet".

2. Choose the Totals button on the list toolbar. SharePoint displays a total for each numeric column, as shown in Figure 6-6.

   

   Figure 6-6. Displaying totals in the datasheet view

The second way to view totals is to add them to the standard list view. This approach isn't as useful as the first, because it doesn't total calculated columns. To add totals to the standard view:

1. Choose "Modify settings and columns".

2. In the Views section, choose the view you want to modify. The default view is All Items. SharePoint displays the Edit View page.

3. Expand the Totals section and select the type of total you want displayed for each column, as shown in Figure 6-7.

4. Choose OK when you're done. SharePoint adds the column total to the top of the standard view.

Figure 6-7. Adding totals to a view

Note

If you don't see the choices shown in Figure 6-7 ...