Identifying Data Characteristics

Question

Hi - I have a data set with customers and products (see picture for example) for a beginning and ending period. I'd like to identify certain characteristics including whether it is a new customer, new product, lost customer or lost product. Looking for a simple way to achieve that.

Customer Product Qt EndQt BegNew Customer New Product Discontinued Product Lost CustomerA 1 1 – x  A 2 1 1    A 3 – 1  x B2 1 –    B3 – 1  x C21 –x   D2 – 1   x

Thanks in advance for the help

Mimzz96 · Answer

Customer A Product 1 is sold in End period but not beginning, so it is a new product but not a new customer (since customer A was in period beg and end)

Customer C is a new customer because in period end but not beg

Customer D is a lost customer because in period beg but not end

Customer A Product 3 is a discontinued product because it is sold in period beg but not in period end

Qiu · Answer

@Mimzz96 
I mean your output is the flag for below, right?

New Customer New Product Discontinued Product Lost Customer

How can we flag them? from your input

Customer Product Qt EndQt Beg

Mimzz96 · Answer

I basically need it to be either a 1 or 0 for all categories, to use as a multiplier for sales...