I am looking to set up three dropdowns at the top of a web part page that will allow the user to choose Week#, Region and Site in order to show a specific item (or items) from a Sharepoint custom list in multiple webparts below.
For example, I go to the web part page, choose Week 15 from the first dropdown, Region: Northwest from the second, and Site: Seattle from the third. The multiple webparts on the page would show the items in the lists that match all three parameters.
It's a SP2010 web part page with multiple DVWP. All web parts should be filtered when selections are made in the dropdowns. I have SP Designer, but do not have InfoPath (because I am running office 2013).