I wanted to implement a feature just like this and I found a solution (just read the answer):
http://community.retool.com/t/how-do-i-dynamically-filter-by-multiple-dropdown-boxs-will-this-work/9810
I hope you'll get the answers that you need from there, otherwise, do not hesitate to ask for help!