Pivot Table Values

[tatooedsn]

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

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​

 

[JimM]

Right click on a cell in the count col of the pivot table, click 'Value field settings' and select sum ie so it's sum of Count, not count of Count

 

[tatooedsn]

Right click on a cell in the count col of the pivot table, click 'Value field settings' and select sum ie so it's sum of Count, not count of Count

Hi Jim. I already tried that and my values all go to "0"

 

[tatooedsn]

It seems to work when I don't use a filter for which machine I want this data to show up for.

 

[tatooedsn]

I think the fact that the machine error has duplicates in the table could have some effect on this issue I'm having.

 

[tatooedsn]

Somehow I need to add the number of errors for rows that have the same error like below and then use that total for my pivot table :-/ I.e. no backing card present shows up twice and has a total number of errors of 10.

W1/PE1002 NO BACKING CARD PRESENT	3
W1/PE1002 NO BACKING CARD PRESENT	7

W1/PE1002 NO BACKING CARD PRESENT	8
W1/PE1002 NO BACKING CARD PRESENT	4
W1/PE1002 NO BACKING CARD PRESENT	14
W1/PE1002 NO BACKING CARD PRESENT	1
W1/PE1002 NO BACKING CARD PRESENT	15
W1/PE1002 NO BACKING CARD PRESENT	9
W1/PE1002 NO BACKING CARD PRESENT	6
W1/PE1002 NO BACKING CARD PRESENT	2
W1/PE1002 NO BACKING CARD PRESENT	15
W1/PE1002 NO BACKING CARD PRESENT	8
W1/PE1002 NO BACKING CARD PRESENT	5
W1/PE1002 NO BACKING CARD PRESENT	12
W1/PE1002 NO BACKING CARD PRESENT	4
W1/PE1003 NO WEB PRESENT STATION #1	2
W1/PE1003 NO WEB PRESENT STATION #1	4
W1/PE1003 NO WEB PRESENT STATION #1	1
W1/PE1003 NO WEB PRESENT STATION #1	5
W1/PE1003 NO WEB PRESENT STATION #1	6
W1/PE1003 NO WEB PRESENT STATION #1	2
W1/PE1003 NO WEB PRESENT STATION #1	1
W1/PE1003 NO WEB PRESENT STATION #1	12
W1/PE1003 NO WEB PRESENT STATION #1	1
W1/PE1003 NO WEB PRESENT STATION #1	2
W1/PE1003 NO WEB PRESENT STATION #1	6