Sum up a calculated column's values for each user in Sharepoint 2007?

Question

Hello,

I've been looking around for quite some time, and I'm not entirely sure how to accomplish this in Sharepoint 2007.

I'm trying to create a web part view that takes the entries of a particular data source, groups the entries by the user, and then sums up a calculated column from said source.

I've found similar tutorials online about creating the web part views and making calculated columns; however, I can't figure out how to sum up the columns for each user listed.

Any ideas?

Answer 1

If you are using a List View Web Part, modify your view by selecting "Modify this view" in the view-picker (drop down list at the top right of the web part).

On the view settings page, expand the Group By section and specify which column(s) you will group by. Expand the Totals section and select which aggregations you want to perform on which columns.

Click OK.

The results are overall totals at the top of the column, and group totals above each group.