how to query the SUM total of a sharepoint list
I have multiple lists in sharepoint that create a SUM for each list item. I am looking for a way to query those individual column SUM's. I would like to be able to query those SUM's for use in charts and other reports. Can this be done?
June 21st, 2010 6:30pm

Hi, If you want to sum columns’ value of same list item, you can use the Calculated Column. If you want to sum same column of all list items, you can use the Event Handle to update the sum column base specified rules. Hope this helps Thanks! Stanfford
Free Windows Admin Tool Kit Click here and download it now
June 24th, 2010 6:09am

I need to clarify what I am trying to accomplish. I have a few lists with multiple columns in each list. Each column creates a SUM total for that column. I want to be able to capture/query the SUM total from each seperate column. This captured/queried data would be used for reports, graphs, etc. How do I capture/query each SUM total?
June 24th, 2010 5:47pm

you need define how to calculate the sum total. please give a simple eaxmple, how do you want to calculate the sum total. i thinks this is programming issue if you will use the event handle.
Free Windows Admin Tool Kit Click here and download it now
June 25th, 2010 4:41am

SUM=5 SUM=10 1/1/2010 2 5 1/2/2010 3 5 Here is an example of two columns I have in a list. I want to be able to capture/extract/query, whatever, the individual value that appears in the SUM fields. Can this be done????
July 6th, 2010 8:39pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics