I have to create a calculated field base on the original data.
I have buyer names for several quarters, and I need to identify wheter it is a new buyer or an existing one by quarter.
So the logic should be like this:
Compare the Buyer Names for each Quarter, and compare them to the Buyer Names from the previous four Quarters.
If the Name exists in the previous four Quarter then is and existing Buyer
If the Name does not exists then it is a new Buyer
Also I would like to know if this could be done in the script or as an expression...
Thanks in advance for any help.