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 need to sum a column based off of a 'type' column. For example, I have four items and two columns,

Type 1  |  val
Type 1  |  val
Type 2  |  val
Type 2  |  val

I need the sum of all Type 1 items, Type 2 items, etc. in an out-of-the-box solution or SharePoint Designer. I'm going to use an Excel Web Query to grab the information, so this needs to display just the type and the summed values.

EDIT:

For a bit better information in understanding exactly what it is I need, the situation would look like this;

List:
Type 1  |  2
Type 1  |  3
Type 2  |  4
Type 2  |  5

Result:
Type 1  |  5
Type 2  |  9

I've tried using SharePoint designer DVWP with a footer for each type, then summing the nodeset and then deleting the rows above and leaving just the footers. Problem is, it doesn't show all information.

share|improve this question
    
Everyone who wants to do BI stuff is using 2007 these days, if you need to do any reporting, collation of data etc in SharePoint I strongly recommend moving to SharePoint 2010 and taking advantage of the wealth of BI tools available instead of patching things together. PowerView and PowerPivot are amazing tools and they can make connections to almost any data source including ssas. –  Hugh Wood Oct 23 '12 at 7:38
add comment

1 Answer

up vote 2 down vote accepted
+50

If layout/display is not an issue then probably you can create ListView with Group By and Total options. This will give you exact result what you need to show. I had created one list view where I am showing total price per product category. Here is my list view screen shot if this is something similar to what you want to show

List view screen shot

Hope this helps!!

share|improve this answer
    
Care to explain how to enable the totaling? The question asks HOW to do this. –  RJ Cuthbertson Oct 23 '12 at 14:29
    
This actually set me on the path to find the answer, THANKS! It got me thinking more on totals... I just used a DVWP in SPD, grouped it by the type, added a sum footer, and used the sum($nodeset/@column) for each column, then deleted the rows and left the footer. Using SPD, I could format it perfectly for the Excel Web Query! Thanks again. –  Christopher Oct 24 '12 at 10:52
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.