1 Reply Latest reply on Sep 30, 2018 10:09 PM by lei.chen.0

    number new, renewed and lapsed subscription help

    Imran Azam

      Hi All

       

      i am working on a task at work and i need to work out how many subscriptions have been renewed , lapsed and new

       

      below are the rules i am using

      • if total in previous period and not in this period = Lapsed 

      •         If total in previous period and this period = Renewed  ---

      •         If the delivered revenue in current period but not in previous period ( or start date is 2014) = New.

       

      from the tableau sheet i have attached i am trying to create something like the below

       

       

      Status2014
      2015
      2016
      2017
      2018
      20192020
      New111
      Renewed122211
      Lapsed11

       

      how can i do this?

       

      any help would be good

       

      thank you