Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

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

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.

Related Topics:

- Pivot Tables Calculations
- Changing Chart attributes without activating the sheet/chart
- User Function - is optional calculation possibe?
- DISK SPACE CALCULATION
- Constructors in calculation
- Disabling Formulas, Not calculation
- time calculation
- adds =round(cell references,5) to allocate the calculation to 5 places
- Time taken - Calculation
- Time difference calculations across midnight
- Code for Pivot table date change
- Refreshing Pivot Table
- Change data source for a pivot table
- Calculate fields (Pivot Tables)
- Disable Pivot Toolbar
- Pivot Table Macro
- Finding the name of pivot table
- Date range in pivot table
- Find the name of the pivot table on the activesheet
- retrieve data from a pivot table
- Date Ranges in Pivot Table
- Date range in pivot table
- Find the name of the pivot table on the activesheet
- retrieve data from a pivot table
- pivot table fields grouped by partial values