Count layers in a list?

OSUBlakester

Hi,

 

I am looking to count the number of layers (not descendants) in an employee hierarchy.

 

For example:

Manager 1 has 3 direct reports

Mananger 2 reports to Manager 1 and has 4 Direct Reports

Manager 3 reports to Manager 2 and has 1 Direct Report

 

The result would be:

Manager 1 has 3 levels

Manager 2 has 2 levels

Manager 3 has 1 level

 

Any idea on how to calculate that?  I have a list that has the employee reporting hierarchy.  I had tried to add a level calc, but cases where there are multiple people reporting to the same manager (siblings) is causing a problem.

 

Thanks!

 

DavidSmith

@OSUBlakester 

1. What you'll first need to do is check for each manager for each level. You will need a line item for each level to the maximum that you know you might have

2. Then add a line item (Count) with a '1' formula

3. Add another line item (Level Count), and check for each level for the maximum number of levels using the MAX aggregation method.  You need the MAX function to eliminate -Infinity in the results

Hope this helps

David