8 Replies Latest reply on Nov 18, 2016 3:08 PM by Sherzodbek Ibragimov

    Total Active members trended by comparing enrollment date and cancellation date?

    Maximus Decimus Meridius

      I have a dataset that looks like this

       

       

         

      Member_idEnroll DateCancel Date
      1233/24/20134/4/2013
      1243/24/2013
      1253/24/20135/27/2013
      1263/25/2013
      1273/25/2013
      1283/25/20134/16/2013
      1293/25/20137/2/2013
      1303/25/20135/28/2013

      etc

       

      That is, it has members with enroll date and cancel date (if cancel date is missing it means they are still active). What I want to do is create a simple trended line to show the number of active members by date, but I'm not sure how to proceed. It will be the total number of enrolled members - the number of cancelled members at each date, but I'm stumped - anyone know how to do this? If needed I can upload a workbook with a larger dataset but it will follow the format above

       

      Thanks!