Org Hierarchy - Find Direct & Indirect reportee to specific manager

[wdwjbkj]

Hi Team,
I need help. I need to calculate How many employees are reporting to Manager. the hierarchy is like: Level 1 & Level2 reports to Level3. Level3 Reports to Level4 & Level4 Reports to Level5 (Manager)
for example with number of employees:
10 employees under Level1 & 10 Employees under Level2 reports to Level3 (there are 4 Level3 employees in a team)
these Level3 employees reports to Level4 (there are 2 Level4 employees)
these Level4 employees reports to Level5 who is a manager.

So, I need to calculate How many Level1, 2, 3 & 4 Reports to Level5. (there are 2 Level5)

if there any formula, please guide. thank you.

 

[pecoflyer]

Adding a sample file with some data and manually calcualted expected results would be a great help (no pics please)

 

[wdwjbkj]

thank you for the reply. I have attached dummy data.