I did some checking around and can't seem to find a show condition for the object I am using...I can use the conditional calculation, but I'm attempting to modify based on dimensions. From what I've read, I'll need to build an array with the dimensions and measures in the script in order to do this.
Since I'm not the most technical person, I've instead decided to set up two sheets; one for geographic and one for organizational structure. I'll use navigation buttons to send the user to the correct view...just need to make sure I build in a back button and consider how to ensure the filters are cleared when moving back to the overview. Since this is getting off topic, please do not feel obliged to respond.
thanks again for your help.