Hi,
I have a requirenment like this,
| Empcode | Month | Manager ID |
| 1 | Jan | 101 |
| 2 | Jan | 101 |
| 3 | Jan | 101 |
| 4 | Jan | 102 |
| 5 | Jan | 102 |
| 6 | Jan | 103 |
| 7 | Jan | 103 |
| 1 | feb | 102 |
| 8 | feb | 102 |
| 9 | feb | 104 |
| 10 | feb | 104 |
| 11 | feb | 106 |
| 12 | feb | 106 |
| 13 | feb | 107 |
| 19 | Mar | 104 |
| 20 | Mar | 105 |
| 21 | Mar | 105 |
| 22 | Mar | 102 |
I want Report Like below Chart and the conditions are
- New manager will be defined as any person who is a manager in the current month and not a manager on the previous month.
- Low Count of reportees manager will be having the reportees<=2(reportees=no of empcode report to Manager ID)
- The ageing will be calculated as the number of months the manager is continuously having low Count of reportees
| Ageing --> |
| Month | New Manager as Ageing 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 13 |
| Jan | 3 |
| Feb | 3 | 1 |
| Mar | 1 | 1 | 1 |
| | | | | | | | | | | | | | |
Any Help would be appreciated.
