We help IT Professionals succeed at work.

SharePoint 2007 Sum Column

Capt_Ron
Capt_Ron asked
on
I have a SharePoiint list that contains a bunch of columns.  
The important ones are:
Title
School
Start Time
End Time
Minutes
Hours
I need to be able to group by School, filter by a date range on the Start Time column and receive a total of Hours.
I have tried a DVWP but I can't get the footer columns to show up.  When I click the Advanced button on Grouping/Sorting and choose column footer totals, they don't show up.
I'm a complete noobie to XSLT, but if I can get an example that is easy to follow, I can probably work with that.
Any ideas?
Thanks
Ron
Comment
Watch Question

Capt_RonIT Solutions Manager

Author

Commented:
Update:
I got it to work.  But my list contains 10,000+ items.  I'd like to pre-filter the DVWP to only pull items within the last 30 days.

Thoughts?

Commented:
hi there create a calculated column  and add a formula "=[Created]-31" to calculate the 30 day period after that create a view and filter by the calculated 30day period
Commented:
once you create a calculated column you can also select the column in the data view and filtering the data

Explore More ContentExplore courses, solutions, and other research materials related to this topic.