MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Pivot Tables Calculations

  Asked By: Carlton    Date: Aug 28    Category: MS Office    Views: 771

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



1 Answer Found

Answer #1    Answered By: Tate Thompson     Answered On: Aug 28

Use the pivot  toolbar and then go to Formula - Calculated Fields, and now create
a formula that you want on the data  items. If you want you can record this
macro also

Didn't find what you were looking for? Find more on Pivot Tables Calculations Or get search suggestion and latest updates.