MTD

[#1]

Hi All

Submited By	False Alert	=[Sam Ref Id]
1158631: Degalesan, Raghunathan - 02/03/2015 10:48:28 PM#	L2/L3 Approved	SAM123102286552
1158631: Degalesan, Raghunathan - 02/03/2015 10:56:38 PM#	L2/L3 Approved	SAM123102286573
1158631: Degalesan, Raghunathan - 02/03/2015 11:21:16 PM#	Auto Approved	SAM123102286683
1163317: palanikumar raman - 05/03/2015 08:47:23 PM#	L2/L3 Approved	SAM529106947601
1166466: Srinivasan Gayathri - 03/03/2015 07:43:49 PM#	L2/L3 Approved	SAM123102289503
1166466: Srinivasan Gayathri - 04/03/2015 08:46:45 PM#	L2/L3 Approved	SAM123102293281
1166466: Srinivasan Gayathri - 08/03/2015 05:26:02 PM#	L2/L3 Approved	SAM123102303422
1166466: Srinivasan Gayathri - 25/03/2015 05:57:14 PM#	L2/L3 Approved	SAM123102303474
1166466: Srinivasan Gayathri - 26/03/2015 10:53:17 PM#	L2/L3 Approved	SAM123102304200
1166466: Srinivasan Gayathri - 16/04/2015 10:36:15 PM#	L2/L3 Approved	SAM123102327431
1166466: Srinivasan Gayathri - 17/04/2015 05:03:32 PM#	L2/L3 Approved	SAM124102328599
1166466: Srinivasan Gayathri - 18/04/2015 09:02:07 PM#		SAM123102331772
1166466: Srinivasan Gayathri - 23/04/2015 05:18:10 PM#	L2/L3 Approved	SAM124102343668
1166466: Srinivasan Gayathri - 24/04/2015 04:29:35 PM#	L2/L3 Approved	SAM123102348301

Need to find the distinct Sam Ref Id for the Max Month and Previous Month where false Alert not equal to Auto Approved.

[florentina_doga]

I've attached  an example for this problem.

[#3]

HI

I want to find the Max Month MTD with Previous MTD