Apologies if this was answered by another question somewhere - took a look and couldn't resolve this exact one.
I have a report that generates many duplicate rows with "same name, same name, same activity" which are undesired; but also have "same name, same name, different activity" which are what I'm specifically looking for.
How do I filter to remove the "complete duplicates" but not the "partial duplicates"?
[An excel version of what it looks like in salesforce - wanting to keep both of the bottom pair, but only one of the middle pair]
Create row level formula which will return true/false based on those two field.
If( field1 == field2 , true, false)
Use formula in filter as false
So only row will be displayed which has field1 & field2 different value
