Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a calculated column in a list and I would like to get a sum of that column in the view. I can't use datasheet view, and I don't like the idea of a workflow because the user only sees a few records that are being summed. Any suggestions?

share|improve this question
    
What are you using to view your data? Data View Web Part? How are you filtering the records being shown to the user? –  Jim Bob Howard Apr 24 '12 at 4:05
add comment

5 Answers

If you are using a SharePoint data view you can display the count of a column using XSL

< xsl:value-of select="sum(/dsQueryResponse/Rows/Row/@ColumnName)" />  
share|improve this answer
add comment

I don t there is a direct way to do this. Please check the link below.I hope this would help. http://community.bamboosolutions.com/blogs/bambooteamblog/archive/2009/04/24/how-to-total-calculated-columns-in-a-sharepoint-list.aspx

share|improve this answer
    
this one refers to SharePoint Designer 2007, and the menu structure is quite different in 2010... –  Mark Latture Dec 1 '11 at 15:14
add comment

Can you check this post and get some idea?

http://geekswithblogs.net/SoYouKnow/archive/2010/03/30/sharepoint---summing-calculated-columns-by-groups-dvwp.aspx

share|improve this answer
    
This one is also an SP2007 post. –  Mark Latture Dec 5 '11 at 18:41
add comment

I hate bubbling old topics up, but I ran across this thread today and noticed it had lots of views and no answers.

A really simple way to do this is to create a workflow that runs automatically on new/edit list items and all it does is copy the calculated value to a "normal" number column and then sum that column in the view.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.