unique records in pivot table
 

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!
--
maryj

unique records in pivot table
 

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.
--
maryj


"maryj" wrote:

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!
--
maryj