i have an issue with pivot charts
I made a pivot chart.
The pivot field lists are "location", "Week_number", "Supplier_Status"
and Suppliers name". The data field is the shipment volume. So for
each location, for each week, for each supplier type and each
supplier, there is a shipment volume. And of course the piviot table
gives a total (total of various supplier_status types, total for
various weeks and then total for each locations.

now i want to have a percentage contribution of each supplier against
that week's total.

For e.g.,
Location is Bangkok
Week_num is 1
Supplier_Status are Green and Orange
The Vendors are A, B, C in Green
The Vendors are D in Orange.

I want how much is the percentage contribution of each vendor for that
particular week. Can somebody help me how to do it? This is just one
data. I have tons of records in a similar fashion