O/P needed like this

Hi SDN's

i had created the dynamic internal table for the below req. now wht i wnt is how do i sum up the amounts and move amounts to respective columns based on the Charge Code

Alloc no|ChargeCode	|Amount	|
---------------------------------
A119	|301		|100	|
A119	|301		|200	|
A119	|302		|150	|
A119	|302		|250	|
A119	|303		|100	|
A229	|301		|100	|
A229	|321		|100	|
A239	|301		|100	|
A239	|303		|50	|


Alloc No|301	|302	|303	|321	|
-----------------------------------------
A119	|300	|400	|100	|NIL	|
A229	|100	|NIL	|NIL	|100	|
A239	|100	|NIL	|50	|NIL	|

Regards

Pratyusha