View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
 
Posts: 425
Default Using calculated fields to count unique items in a pivot table

I have a list that summarizes the production of my employees.
The pivot table breaks down their total production by hour.
How do I get a count of the employee names for each hour?
(count unique items)
I can only assume that I will have to enter a calculated field name
and formula...?