Forum Discussion
Headcount movement
I have a Headcount Table as below.
| Month | Empid | DOJ | Manager |
| Dec-23 | 1 | Mar-20 | James |
| Dec-23 | 2 | Jan-19 | Tom |
| Dec-23 | 3 | Dec-22 | Alen |
| Dec-23 | 4 | Sep-21 | James |
| Dec-23 | 5 | Jun-22 | Alen |
| Dec-22 | 6 | May-19 | James |
| Jan-23 | 1 | Mar-20 | Tom |
| Jan-23 | 2 | Jan-19 | Tom |
| Jan-23 | 3 | Dec-22 | Alen |
| Jan-23 | 7 | Sep-23 | James |
| Jan-23 | 5 | Jun-23 | James |
| Jan-23 | 6 | May-23 | Tom |
| Jan-23 | 8 | Jan-23 | James |
| Jan-23 | 9 | Jan-23 | Tom |
Based on this table i need to create a table that show how many new Hire, Employe moved out and move In and attrited employees based on Manager. Below is the output that am looking for. Please help me to achive the below output.
| Manager | Dec-22 HC | Transfer In | Transfer Out | Exit | New Hire | Jan-23 HC |
| James | 3 | 1 | 2 | 1 | 2 | 3 |
| Tom | 1 | 2 | 0 | 0 | 1 | 4 |
| Alen | 2 | 0 | 1 | 0 | 0 | 1 |
No RepliesBe the first to reply