Identifying Data Characteristics

[Mimzz96]

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 End	Qt Beg	New Customer	New Product	Discontinued Product	Lost Customer
A	1	1	–		x
A	2	1	1
A	3	–	1			x
B	2	1	–
B	3	–	1			x
C	2	1	–	x
D	2	–	1				x

Thanks in advance for the help

[Qiu]

@Mimzz96 
Can you provide a logic how the input beomes output you need?

[Mimzz96]

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

[Qiu]

@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 End

Qt Beg

[Mimzz96]

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