Can you help me with this pivot table. I get confused where to put the data.
Table should have Department Mgr Name, Dir Name, Count Total # of employees (first name column, last name column), Count # of Completed, Count # of not completed. Pivot table added to existing sheet.
Hi Mymalone,
You haven't said how you determine completed vs not completed and there are no columns labelled as such.
You also haven't said if you want a distinct count of employees, i.e. don't count any employees listed twice (if that's possible, I don't know).
In the attached file I've created a PivotTable that contains the fields excluding completed/not completed counts. You may need to add columns to your table to include a 1 for completed and 0 for not completed so you can use them in your PivotTable.
Mynda
