Forum Discussion
Flag based on value on multiple rows
Hi, I have a data set that contains a unique value for each customer as well as a column which indicates what offer they received as well as the method of communication (channel). For example; ...
Like this? See last row, a duplicate of the first row with a Y added to Email
Like this? See last row, a duplicate of the first row with a Y added to Email
Hi Greg,
Yours looks exactly how I want it. and even though i've replicated what you've got, I can't get the right outcome. This is very strange!
Many thanks
Greg, you're a star. Everything works perfectly now (I've also added the extra column to filter by).
Appreciate your help!!
You have 2 OB's in your IF statement. One of them needs to be DM. Also, I would use ALL and not ALLSELECTED. Finally, ou have another column which you might need to filter on but I wouldn't worry about that until the other 2 issues are addressed.