Pivot table count function not counting all data.
 

I have the following:

Date Workorder Emergency Code
2/13/06 pr56789 01
2/13/06 pr23459 01
2/18/06 pr95613 03
2/18/06 pr78935 03

I need the count of the Emergency Codes per date. When I create my pivot
table, I get two counts for each code rather than the total. What am I doing
wrong?

Pivot table count function not counting all data.
 

What do you mean, if you get

02/13/06 2
02/18/06 2


then that is correct right? If you get

Feb 2006 4

then you need to make sure you group the dates for days and not months

Regards,

Peo Sjoblom

"Irma" wrote:

I have the following:

Date Workorder Emergency Code
2/13/06 pr56789 01
2/13/06 pr23459 01
2/18/06 pr95613 03
2/18/06 pr78935 03

I need the count of the Emergency Codes per date. When I create my pivot
table, I get two counts for each code rather than the total. What am I doing
wrong?

Pivot table count function not counting all data.
 

How is the layout of your pivot table? You may try to use "Date" and
"Emergency Code" in the rows, and "Count of Workorder" in the data, that
should give you just one for each combination of Data-code.

Hope this helps,
Miguel.

"Irma" wrote:

I have the following:

Date Workorder Emergency Code
2/13/06 pr56789 01
2/13/06 pr23459 01
2/18/06 pr95613 03
2/18/06 pr78935 03

I need the count of the Emergency Codes per date. When I create my pivot
table, I get two counts for each code rather than the total. What am I doing
wrong?

Pivot table count function not counting all data.
 

I get

02/13/06 1
02/13/06 1
02/18/06 2

It is just not capturing all of a particular date.

"Peo Sjoblom" wrote:

What do you mean, if you get

02/13/06 2
02/18/06 2


then that is correct right? If you get

Feb 2006 4

then you need to make sure you group the dates for days and not months

Regards,

Peo Sjoblom

"Irma" wrote:

I have the following:

Date Workorder Emergency Code
2/13/06 pr56789 01
2/13/06 pr23459 01
2/18/06 pr95613 03
2/18/06 pr78935 03

I need the count of the Emergency Codes per date. When I create my pivot
table, I get two counts for each code rather than the total. What am I doing
wrong?