SharePoint University

Hi:

Simplistic question but how can I create a summary of a List.  For example, I have 500 records with 20+ fields.  I want to show a summary of one category [City] of the List. 

New York $525

Boston $645

Los Angeles $1200

I assume I need to create something in SharePoint Designer, but what is that and how might I go about doing it.

Charlie

The simplest way I know to go about this would be to show the view grouped by city and then do a total (SUM) of the amount.

However, this would only show the total amount if the grouping is expanded...

Does that fit your needs?

Hi:

Yea, I have that already but I am trying to create a crunched down view, probably in SPD2007.  It's hard to get away from seeing the details no matter whether a standard List or a custom dataview...  Hmmm

Charlie,
        You can create a dataview webpart or a page using sharepoint designer and then show some summary data.
Try using xslt/xpath.
If you have issues let me know.

Patrick
 

Hi Patrick:

I can do everything except the xslt/xpath... which is the big part.  Is there a primer or tutorial as to how to sum a column in dataview and then only show the sum next to the category?

 ok lets get started
To get a sum do this:

<xsl:value-of select="count($nodeset)" />

To ge a summary you can do this:

<xsl:value-of select="substring(@Title,1,100)" />

What the above does is it show only the first 100 characters of the title node

 See some xpath tutotial here : http://www.w3schools.com/xpath/default.asp

Hope this helps
Patrick

Hi Patrick:

I think I'm out of my league here.  I'll read through the W3 tutorial and ask questions if I think I can move forward.  Thanks for your time.

No worries Charlie.
if you need help just post it.

Patrick