Hi all!

I have what I hope to be a simple question. I have a pivot table with data for managers and employees. The employees appear even if they did not work. I need a way to calculate the amount of employees per manager that did work during the chosen time frame. So far, I was able to create a column that has a 1 if the "calls handled" column is greater than 0 and it has a 0 otherwise. I created that column simply by making a new field in the pivot table where it equals "Calls Handled > 0." However, no matter what I do, I cannot get that column to sum the 1s for each manager. I also need each manager's total to sum for the managers' manager. That's as high as I need it to go, luckily!

Any ideas?