How would we go about creating a table that shows manager counts from the top down. For example the CEO has 6 Chiefs that report to him. The CHRO below the CEO has 2 direct report managers, who each have people they manage. How could we design a report that could start out from the top showing the CEO with a headcount of 6 that report directly to him. Click on him and see all 8 Chiefs with the total manager headcount under each one, then click the CHRO, see the manager headcount of 2, then click one of her managers and see that manager has a headcount of 3, and so on.
But the tricky part is that with each new employee the data needs to automatically refresh and place that new employee into the count for the correct manager, without having to manually add a field to that employee, or also to update if someone gets promoted to a manager position and now should be on that list. We tried something but only got it to show the counts of all managers, but then put all individual contributers as others and bunched them separately.
Something like this…
