Sum Values Based On Distinct Guids

I am having trouble getting the SUM of a column of values in SSRS. My SQL query returns something like the following: ID          Total Guid1    4 Guid2    

Solution 1:

pretty sure you can Sum the grouped field in ssrs.

=SUM(MAX(Fields!value.value,"GuidGroupName"))