Pivot Table - Counting Amount of Certain Rows
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!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1