Records dropping from basic analysis due to filter(s)

Summary:

Content (required):

I have a very basic analysis in obiee that is pulling all active CWK. I need to include Home Email, however, when I filter, I lose ~25% of my population, because they do not have a Home Email. I need a solution to include the field, while keeping the whole population intact. Regardless of whether one of my CWKs has a Home Email or not, if they're active, they should be on my output, and their Home email field blank. It's probably so obvious 😉 Appreciate any/all responses

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):