How to sum duplicated values in a Group (SSRS)

Question

How to sum duplicated values in a Group. SSRS 2008

My query returns values like the following:

But, I want this:

Answer 1

Seeing your existing query and/or schema, plus details of what you've already tried and the problem(s) you ran into would be helpful, but if your original query was:

SELECT [Cus ID], [Cus Name], [Inv Amt]
FROM Invoices

then you want to GROUP BY the [Cus ID] and SUM the [Inv Amt] values:

SELECT [Cus ID], [Cus Name], SUM([Inv Amt])
FROM Invoices
GROUP BY [Cus ID], [Cus Name]