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.