Shreesurya
Board Regular
- Joined
- Jul 7, 2014
- Messages
- 50
Hi Experts,
Need your help to calculate number of people under each manager. Please help me the decode this complications.
<tbody>
</tbody>
Result I'm expect as below.
<tbody>
</tbody>
Please reach out to me if you have any further information is required to help me.
Thank you so much.
Surya Prakash R
Need your help to calculate number of people under each manager. Please help me the decode this complications.
Name | Level | Lead | Manager |
Brian | Level 1 | Alfred | Sheldon |
Erick | Level 1 | Alfred | Sheldon |
Alfred | Level 2 | Sheldon | Raymond |
Sheldon | Level 3 | Raymond | Edward |
Raymond | Level 4 | Edward | Donald |
<tbody>
</tbody>
Result I'm expect as below.
Manager | Level 4 | Level 3 | Level 2 | Level 1 |
Edward | 1 | 1 | 1 | 2 |
Raymond | 0 | 1 | 1 | 2 |
Sheldon | 0 | 0 | 1 | 2 |
Donald | 1 | 1 | 1 | 2 |
<tbody>
</tbody>
Please reach out to me if you have any further information is required to help me.
Thank you so much.
Surya Prakash R