unique records in pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pivot table that is first grouped by dept then by employee name. I
need to get a count of employees in each department. Doing a count of the
employee field gives me a count of each the number of records each employee
submitted. I saw Debra Dalgleish's suggestion of using a if(sumproduct)
formula in the raw data - the problem is, this data is from an external data
source and I don't have access to make changes in the orginal data. Any
suggestions? Thanks!
 
I think I found a workaround.
I used the Database query option and created a query to list all the
departments and the employees. I can use this to generate my count of
employees for each department, using countif, that will be dynamic to use in
my formula rather than referencing data from within the pivot table.
 
Back
Top