Hi All,
I have a dimension of monthname(date), so it's in the form of MonthYear.
I want to count customers who were active (had an order) in the month prior to the month in a row and DID NOT have an order in the current row month.
Ideally I want to do this in Set analysis.
To put this in context I have done Acquisitions - this is the customers who did not transact in the prior month but have in the current month. I did this by creating a flag during the load script and then using set analysis. The problem with the reverse (lapsed) is that these customers will not have an order in the current row month.
Thanks in advance!
GPC
