View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Irma
 
Posts: n/a
Default 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?