Hello Folks. I'm having issues with my values showing up correctly on my pivot table and chart. Basically I have a table with 2 columns. One column is a machine alarm and the 2nd column is the number of times that alarm occurred. Now when I create a pivot table from this, I use the machine alarm for the Row field and alarm count for the Values field. Since the Values field counts, it changes my alarm count to another number. Any idea of how to resolve this so I can just have my alarm count be my value field that is in my table?
Worksheet Table
Pivot Table
Worksheet Table
Alarm | Count |
W1/PE1002 NO BACKING CARD PRESENT | 3 |
W1/PE1002 NO BACKING CARD PRESENT | 7 |
W1/PE1003 NO WEB PRESENT STATION #1 | 5 |
W1/PE1004 NO WEB PRESENT STATION #2 | 8 |
W1/PE1004 NO WEB PRESENT STATION #2 | 20 |
W1/PE1005 NO WEB PRESENT STATION #3 | 1 |
W1/PS1001 SYSTEM LOW AIR PRESSURE | 1 |
W1/RUN TIMEOUT, CHECK MATERIAL PAYOUT LOOP | 3 |
W1/SOL1001 SAFETY SOLENOID STUCK OFF | 1 |
W2/PE1, TAKE-UP, DRV1 OVERSPEED | 1 |
W2/PE1, TAKE-UP, DRV1 OVERSPEED | 4 |
Pivot Table
Date | (All) |
Machine | Lam1 |
Row Labels | Count of Count |
W1/PE1002 NO BACKING CARD PRESENT | 2 |
W1/PE1003 NO WEB PRESENT STATION #1 | 1 |
W1/PE1004 NO WEB PRESENT STATION #2 | 2 |
W1/PE1005 NO WEB PRESENT STATION #3 | 1 |
W1/PS1001 SYSTEM LOW AIR PRESSURE | 1 |
W1/RUN TIMEOUT, CHECK MATERIAL PAYOUT LOOP | 1 |
W1/SOL1001 SAFETY SOLENOID STUCK OFF | 1 |
W2/PE1, TAKE-UP, DRV1 OVERSPEED | 2 |