View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Sandy is offline
external usenet poster
 
Posts: 355
Default Count within pivot table

I have a pivot table sorted by two fields; budget unit and employee name. My
source data has each employee with several rows of data (so the names show up
several times). I need a count of employees in each budget unit, not a count
of the occurence of the employee name. How do I do this? Thank you for your
help.