Help on Ageing and Addition of Records

[#1]

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.