anils

I am fetching the result from Stored Procedure. I don't have access to modify the SP. The Data I am fetching in this order counter party Amount ************* ******* c1 500 c1 200 c1 300 c2 500 c2 700 c2 800 c3 200 c3 900 c3 500 I want to display Counter Party Amount Percentage ************* ****** ******* c2 2000 43.47% c3 1600 34.78% c1 1000 21.73 Is it possible to achieve this functionality? Struggling a lot not able to do it. Any help will be greatly appreciated.