This content has been marked as final. Show 4 replies
Just need some help with set analysis. This is my data set.
|C00001||3/31/2010 2:39:52 PM||03/21/2010||Mar||0|
|C00001||4/20/2015 8:57:35 AM||04/20/2015||Apr||2|
|C00001||4/20/2015 11:50:15 AM||04/20/2015||Apr||0|
I want to count only max(Status) of an particular [Account Num] for each Month. where status should be '0'. and there are many Other account numbers as above .
Ex. i only need to count those record which are having status = 0 for the max date of that month . like two of the record which are Bold ,i only need to count those. how can i do it in set analysis.