SQL Server Report getting total amounts

[jsc0624]

Hi Guys I have a problem with SQL Server Reporting Services.

I have a record on my database something like this:

Description Amount
Item A 25.00
Item A 25.00
Item B 25.00
Item B 25.00
Item C 25.00
Item D 25.00
Item D 25.00

But in my report I just want to view Item A and Item C with their Totals:

Description Amount
Item A 50.00
Item C 25.00

Thanks in advance.

[RhinoBull]

Would this work for you?

Select
    Sum(Amount) As Total_Amount
Where
    Description in ('A', 'C')
Group By
    Description