@Syed Hamd Salman, Thank you for the Case Statement this works perfectly. I appreciate the assistance. I can see how to nest these Case Statments now and use 'IS NULL' rather than IFNULL() (I also neglected to input the second argument for this haha) A lot of room for improvement. @ Pedro F, You're right. Definitely missed…

@Thomas Dodds We have Employee Age available in a different Subject Matter Area (EOM Frozen data). Which is not the one I need to use. Would like to avoid doing subsequent calculations....

@Gianni The scope is set to Page for all prompts in the option you reference above. Is it possible that this is some sort of issue with the software itself? The behavior is inconsistent.... sometimes it saves the Filter for Region when switching pages and sometimes it doesn't.

Gianni, Thanks again for the help. I tried to edit my previous post to add this information but, I did not see an edit button. I found the option in the dashboard itself as well. I see that the option on the Dashboard Page when I right click on the Prompt has the Scope selected as Page with a blue dot beside it. 

I looked at the prompt and it appears that it is not set to all pages. Is this the option you're referencing or is it specific to the fields within the prompt

Thanks for the input. I'll keep this method at the forefront of my mind

Right now I have it sorted descending with only 10 rows showing at one time as the default setting... Which is a good work around for the situation. However, I'm just wondering what is going on that is causing the issue to begin with so that I can be aware of the root cause of the issue and whether or not it would effect…