MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Pivot Charts - Custom Calculations

  Asked By: Waldemar    Date: Jan 05    Category: MS Office    Views: 794

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



2 Answers Found

Answer #1    Answered By: Joann Gardner     Answered On: Jan 05

You can use the calculated item field  for custom  calculations. [ In the
insert menu ]

Answer #2    Answered By: Madeeha Malik     Answered On: Jan 05

I tried to use the calcualted field. but the problem that i described above
does not get solved in the calculated field. I have been using this
calculated field  thing for quite sometime.

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