<div>
Update:<br />
I got it to work. &nbsp;But my list contains 10,000+ items. &nbsp;I'd like to pre-filter the DVWP to only pull items within the last 30 days.<br />
<br />
Thoughts?<br />

</div>


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?


<div>
hi there create a calculated column &nbsp;and add a formula &quot;=[Created]-31&quot; to calculate the 30 day period after that create a view and filter by the calculated 30day period
</div>


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

<div>
<div class="content wysiwyg-content">
I have a SharePoiint list that contains a bunch of columns. &nbsp;<br />
The important ones are:<br />

<div class="bullet">
Title<br />
School<br />
Start Time<br />
End Time<br />
Minutes<br />
Hours
</div>
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.<br />
I have tried a DVWP but I can't get the footer columns to show up. &nbsp;When I click the Advanced button on Grouping/Sorting and choose column footer totals, they don't show up.<br />
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.<br />
Any ideas?<br />
Thanks<br />
Ron
</div>
</div>


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

SharePoint 2007 Sum Column

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.