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 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
how can i do this?
any help would be good