Percentage Contribution of an Account

Dear All,

I need to find out the weight of a particular account and the percentage that it has contributed to the overall market shrinkage/growth.

I have tried all sorts of possible functions but, no luck!

I have attached the example.

Thanks in advance!

What's wrong with current formula? I see you got 100% overal so it might be OK.
What result do you expect?

Yes, I have the weight of the account, but I am trying to find out the % contribution each account has made (taking the weight into consideration) to the overall shrinkage of the market.

Thanks!

Can someone please help me with this request urgently!

I really need to hand in a report ASAP, appreciate your support!

Thanks again!