Ok.. hopefully i can explain this simply. I am creating an interactive dashboard that uses dropdown boxes and then filters several pivot tables based on the dropdown slections. The dashboard will allow different combinations of country and business entities to show different metrics (different metrics are in each of the pivot tables). My only issue is that the lists i have in the dropdowns is an exhaustive list of everything available but that some pivot tables only contain data for a few countries/entities, so when one of these is selected it fails.

Funny thing is though, that when it filters on a data field and the slection is not availble it doesn't fail and just leaves the pivot with absolutely nothing selected. This is what i want. But when it filters on a page field, it fails because it can't find the selection. I've searched high and low for this and can't seem to find a solution. 

Please Login or Register  to view this content.
I'm sure this isn't the most efficient way to write this code- i'm quite new to this and trying to self teach. Can anyone help?