Combining line items in a report

[kkershaw]

I have a field named "manifest" that often has duplicate values. I would like to combine the duplicate "manifests" into one line item in a report. Example

Manifest Amount
12345 15.00
55555 10.00
55555 5.00 should read as

Manifest Amount
12345 15.00
55555 15.00

Thank you.

 

[kkershaw]

I have tried that, but the problem I have is that some of the fields in my query are calculated fields, and I get an error when I try to sum those fields. Any suggestions?

Thanks