Calculated Pivot Table Columns

[Jeff]

I have a Pareto Chart that has as the row a list of part numbers. The
columns are different defects for each part number. By default I've got the
chart calculating the grand total.

I would like to have the chart automatically calculate the %Scrap for each
part number.

Just to be clear...if I produced 100 parts for the specified time frame and
when you add all the defect causes together, the sum is 14, I would like the
pareto to display 14% for total scrap.

Any thoughts?

Thanks

Jeff

 

[Ashish Mathur]

Hi,

Could you paste the pivot output here

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com