Software

Ask something
Discussion Locked

Pivot Table data calculation

0 helpful
3 replies

by brianlloyd

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is pivot table data controllable beyond sum, count, etc? Simplified, I have a table in EXCEL (2002)with column headings listing machine, good pieces, bad pieces, scrap %, and a dozen other data. There are multiple rows per machine, added daily. I have a pivot table that will summarize good and bad pieces per machine. I want to show an overall scrap % for the machine. I can only achieve a sum of the scrap rates. E.g., if machine A produced 1% scrap for 10 days, rather than a 1% overall scraprate, I get 10% - 1 from each of the 10 records, summed. Can I get that column intended to show the overall scrap to do so, and not show a total of the individual scrap %s?

3 replies

by dklippert

Here's one discussion:

http://tinyurl.com/11rc

Also see:
http://edferrero.m6.net/Pivot.html#5

Ifthe data field is Units, you could add another Units field to the data area. In the layout view of the Pivot Wizard, double-click on the secondUnits button.

Click on the Options button
From the 'Show data as' dropdown, choose % of Total
You can also change the name of the field, so the Column is better labelled.
Click OK, click Finish

This discussion is closed to new replies.