InfoPath Dev

Hello, I have a repeating table that is populated from a secondary data source. All of the line items in the data source successfully create a row in the repeating table. I have been able to "hide" elements of the table using formatting rules, however, I want to take this further and filter the results that display in the repeating table. For example, the repeating table pulls in a list of employees. I want to be able to filter this based on another combo box with their location. So only show the rows of the repeating table where the location equals, say, New York. This would give me employees in NY. I can not figure out how to filter a repeating table that has a secondary data source. Thank you!

Attached  a sample form... please modify the data connection to fit your environment  

Key point is the condition for the formatting rule on the repeating table.

Condition: Location(in the secondary source) is not equal to Location(in the main data source, associated to the combo box ) 

or if you prefer reading it in expression, it means  d:Location != xdXDocument:get-DOM()/my:myFields/my:Location