Pivot Table Values

tatooedsn

New Member
Joined
Jun 13, 2016
Messages
25
Office Version
  1. 365
Platform
  1. Windows
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
AlarmCount
W1/PE1002 NO BACKING CARD PRESENT3
W1/PE1002 NO BACKING CARD PRESENT7
W1/PE1003 NO WEB PRESENT STATION #15
W1/PE1004 NO WEB PRESENT STATION #28
W1/PE1004 NO WEB PRESENT STATION #220
W1/PE1005 NO WEB PRESENT STATION #31
W1/PS1001 SYSTEM LOW AIR PRESSURE1
W1/RUN TIMEOUT, CHECK MATERIAL PAYOUT LOOP3
W1/SOL1001 SAFETY SOLENOID STUCK OFF1
W2/PE1, TAKE-UP, DRV1 OVERSPEED1
W2/PE1, TAKE-UP, DRV1 OVERSPEED4


Pivot Table
Date(All)
MachineLam1
Row LabelsCount 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​
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

JimM

Well-known Member
Joined
Nov 11, 2003
Messages
716
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

New Member
Joined
Jun 13, 2016
Messages
25
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Jun 13, 2016
Messages
25
Office Version
  1. 365
Platform
  1. Windows
It seems to work when I don't use a filter for which machine I want this data to show up for.
 

tatooedsn

New Member
Joined
Jun 13, 2016
Messages
25
Office Version
  1. 365
Platform
  1. Windows
I think the fact that the machine error has duplicates in the table could have some effect on this issue I'm having.
 

tatooedsn

New Member
Joined
Jun 13, 2016
Messages
25
Office Version
  1. 365
Platform
  1. Windows
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 PRESENT3
W1/PE1002 NO BACKING CARD PRESENT7
W1/PE1002 NO BACKING CARD PRESENT8
W1/PE1002 NO BACKING CARD PRESENT4
W1/PE1002 NO BACKING CARD PRESENT14
W1/PE1002 NO BACKING CARD PRESENT1
W1/PE1002 NO BACKING CARD PRESENT15
W1/PE1002 NO BACKING CARD PRESENT9
W1/PE1002 NO BACKING CARD PRESENT6
W1/PE1002 NO BACKING CARD PRESENT2
W1/PE1002 NO BACKING CARD PRESENT15
W1/PE1002 NO BACKING CARD PRESENT8
W1/PE1002 NO BACKING CARD PRESENT5
W1/PE1002 NO BACKING CARD PRESENT12
W1/PE1002 NO BACKING CARD PRESENT4
W1/PE1003 NO WEB PRESENT STATION #12
W1/PE1003 NO WEB PRESENT STATION #14
W1/PE1003 NO WEB PRESENT STATION #11
W1/PE1003 NO WEB PRESENT STATION #15
W1/PE1003 NO WEB PRESENT STATION #16
W1/PE1003 NO WEB PRESENT STATION #12
W1/PE1003 NO WEB PRESENT STATION #11
W1/PE1003 NO WEB PRESENT STATION #112
W1/PE1003 NO WEB PRESENT STATION #11
W1/PE1003 NO WEB PRESENT STATION #12
W1/PE1003 NO WEB PRESENT STATION #16
 

Watch MrExcel Video

Forum statistics

Threads
1,129,476
Messages
5,636,556
Members
416,923
Latest member
jarri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top