Query Table Using Filtered Data on Dashboard

Query Table Using Filtered Data on Dashboard

I have one database "SALES" that has a date column, and code column. I have another Query Table "QT" that does some number crunching to get monthly data by code.

When I have a global filter on my dashboard for "Month/Date" on SALES, all of my reports filter just fine except for the QT - That always stays the same. If you filter by code that QT has a lookup column for, it seems to work. Just not any date (since you cant make a date a lookup).

How can you filter a QT by filtering the source by date?