7 Replies Latest reply on Sep 24, 2018 11:01 AM by Hema Latha

    Returning user from previous month

    Hema Latha

      Hi All,

       

      User id
      Visiting month
      User Type
      107-2018New
      207-2018New
      108-2018Returning
      308-2018New
      408-2018New
      209-2018Reactivated
      309-2018Returning

       

      In the above table I need to calculate the 3rd column using the first 2 columns. I have tried using LODs but couldn't find a solution. Would be great if someone can help. Thanks.