megera716
Board Regular
- Joined
- Jan 3, 2013
- Messages
- 146
- Office Version
- 365
- Platform
- Windows
I feel like that's a weird subject but here's what I'm trying to do. I've analyzed year over year sales by customer and identified when a customer was new, if they were an existing customer but their total sales increased, decreased or stayed flat YoY, or if they were lost. (None would indicate if they weren't a customer at all that year and also didn't have any prior year sales against which to compare).
What I would like to do is see, if a customer is "existing account decrease" in a given year, how many years after that before they are a lost customer (if ever). My data is from 2014-2019 YTD so for example on the first row where Loss is highlighted, we would say they were a loss after 1 year (because they were new in 2014, decreased in 2015 and lost 1 year after that in 2016).
I would also like to separately identify how many years do we have a customer before they are lost (as in the second highlighted "Loss"), even if they never have a decrease in sales YoY.
What I would like to do is see, if a customer is "existing account decrease" in a given year, how many years after that before they are a lost customer (if ever). My data is from 2014-2019 YTD so for example on the first row where Loss is highlighted, we would say they were a loss after 1 year (because they were new in 2014, decreased in 2015 and lost 1 year after that in 2016).
I would also like to separately identify how many years do we have a customer before they are lost (as in the second highlighted "Loss"), even if they never have a decrease in sales YoY.