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.
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.