How to add the column in datagridview

Question

I want to add one column in datagridview that calculate the amount of another column in datagridview.

 

For example:

I have data in datagridview that retrieve from database like

 

-Name     Amount

    abc            100

    abc            200

    abc            500

    aaa            200   

    aaa            700

 

I want the result like this !

-Name      Amount      Sum

   abc            100

   abc            200

   abc            500            800

   aaa            200

   aaa            700            900

 

If you have the idea to solve my solution, kindly tell me how to write.

 

Thanks a lot for viewing my question.