Thread: Pivot table count function not counting all data.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Irma
 
Posts: n/a
Default 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?
Reply With QuoteReply With Quote