Join / sign up Explore BA Products
Hi folks,I've had a second issue I've come across and that's using the filter quick function to exclude a piece of data. For instance, I search by communities a lot, and often times they could be missing for whatever reason. If I search for a specific area, it's easier to remove everything that doesn't belong rather than trying to include everything that does as I might miss something the latter way. If something is blank, I do further research to see if it's something that applies or does not, and it's important to keep the blanks.
When using the exclude function however, say for the community of Oakfield, I'll lose out on entries that don't have the field entered where I would manually investigate further. Is there a way to keep the exclude function (as it is incredibly swift and helpful) without removing any null fields in the column?