NEED TAGGING

[lionking15]

ALLO DATE	id	no	calling	CALLING date	NEED TAGGING
1/1/2015	1	1234	C	1/1/2015	NA
1/1/2015	1	1234	C	1/2/2015	NA
1/1/2015	1	1234	C	2/3/2015	NA
4/1/2015	1	1234	NA	4/1/2015	NA
4/1/2015	1	1234	C	4/2/2015	NA
4/1/2015	1	1234	C	5/3/2015	C
1/1/2016	2	1234	NC	1/1/2016	NC
1/1/2016	2	1234	NC	1/2/2016	NC
1/1/2016	2	1234	C	8/3/2016	C
1/1/2016	2	1234	C	8/4/2016	C
1/1/2017	3	12345	NC	1/1/2017	NA
1/1/2017	3	12345	NA	1/2/2017	NA
1/1/2017	3	12345	C	1/3/2017	NA
1/1/2017	3	12345	NC	1/4/2017	NA

I WANT TO ACHIEVE 'NEED TAGGING'

MY PRIORITY IS NA>C>NC(CALLING FIELD)

IF I SELECT 'JAN 2017' I SHOULD CONSIDER CALLING FOR 4 MONTHS(i.e 1/1/2017 TO 4/30/2017) SO MY 'NEED TAGGING' AS 'NA'.SIMILARLY IF I SELECT 'FEB 2017' CONSIDER CALLING FOR 4 MONTHS(i.e 2/1/2017 TO 5/30/2017) AND GIVE TAGGING ACCORDING TO THAT.

[lionking15]

IF a 'no' field is having all NA,C and NC within 4 months (consider calling date) then that 'no' should be tagged as 'NA'  and not as C or NC