1 of 1 people found this helpful
This can be done by creating a string parameter using the list of Countries and creating a calculated field similar to the following:
if [Country Parameter]=[Country] then [Country] end
Then, place this on the filter shelf and Exclude Null. Right click on the Country Parameter and select Show Parameter Control. Then, right click on your State field and select Show Quick Filter. Click on the drop down menu of the quick filter and select Only Relevant Values.
Hope this helps!
Thank you so much for your reply. Your response is very helpful, however I have other sheets using different connections. All other sheets must filter based on the same value of the state. I know I can add the country parameter to all other sheets, but I don't know how to handle the state as country in the other sheets. Do you know how please?
Tracy this method worked great for me.
I'm just having a problem in resetting the filter. What would I add so I wouldn't have to reset the Filter manually?