There is no direct solution to this requirement, however, there is one work around which would be applicable to numerical values (in your case zip is numerical)
1) Create a Calculated field "Filter Duplicates"
2) Paste the below formula into the field
IF LOOKUP(SUM([Zip Code]),-1)= LOOKUP(SUM([Zip Code]),0) THEN
3) Put this calculated field on Filters Shelf
4) Select "Show" as filter
There you go.. Hope it helps..
Thanks for work around. I actually have a lot of rows and this would require manually excluding, right? I need it to be automatic.
Nice! Yes, Lookup is what I was looking for.
However, my next problem is that zipcode is geographic/string field so how would you modify formula to work with string fields as it seems that lookup function requires aggregate or constant fields?
1 of 1 people found this helpful
In that case replace SUM with ATTR. New Formula will look like:
IF LOOKUP(ATTR([Zip Code]),-1)= LOOKUP(ATTR([Zip Code]),0) THEN
awesome, thanks for you help!