Sum the amount using name

[#1]

Though selecting distinct records in Crystal Report because of other fields in the report along with the following two, I am getting values for the two fields as mentioned below

Name Amount

Raja 200

Raja 250

Sekaran 500

Sekaran 500

I tried to insert sum through regular Crystal formula I am getting the following result:

1450

But I need Both values as separate like

Raja 450

Sekaran 1000

Thank you in advance...

[Former Member]

Hi Lan and Vitaly,

I have tried those methods that you told me.

I have sort with ID and sum amount it results as like:

Raja 1450

Sekaran 1450

Thank you in advance