Using information from one visual to filter another.

[Anonymous]

Thanks in advance. Okay, so I have two tables here. And I want to have the production table filter the sanitation table. For example, if I look up dates from Jan 13 to Jan 16. This will give me a set amount of products, batches, and what tanks were used during that date range. The tanks used during those dates should be the only ones that show up in the sanitation table.

Then once only the tanks that are filtered to the sanitation table from production. I want to see those tanks prior to cleaning date/and pass-fail results and 30 after pass-fail results if any. Based on the date range selected from the production dates selected. 

Thanks

[dedelman_clng]

I maybe get what you're going for here, but it would be best if you could expand on the problem that you're facing.  Read this link: How-to-Get-Your-Question-Answered-Quickly  and post the additional information (in the correct format) that will help get your issue solved. Expected results, easy to copy data (not screenshots) and data model usually give most bang for the buck on the forums.

Hope this helps

David