4 Replies Latest reply: Nov 10, 2016 7:11 AM by ankit bisht RSS

    Max Status of Each Account number , year, month wise with set Analysis.

    ankit bisht

      Hi All,

      Just need some help with set analysis. This is my data set.

           

       

           

      Account NumCreatedDateTimeDateMonthStatus
      C000013/31/2010 2:39:52 PM03/21/2010Mar0
      C00001-03/31/2010Mar0
      C00001-04/23/2010Mar

      2

      C00001-04/30/2010Mar0
      C000014/20/2015 8:57:35 AM04/20/2015Apr2
      C000014/20/2015 11:50:15 AM04/20/2015Apr0
      C00001-04/30/2015Apr0

       

      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.