Date filters to work only when selected - not when other date related to date is selected
I have two tables of data that are essentially unrelated. Both tables have a date field. For ease of explanation, let's say table 1 has a date field and a sales field, table 2 has a date field and a score field. If I filter on a specific sales amount, my charts will only show me scores on the dates that have that specific sales amount. I want to still be able to see all scores on all dates. Likewise, if I filter on a specific score, my charts will only show me sales on the dates that have that specific score. I want to still be able to see all sales on all dates. However, when filtering on a specific date, I want to only see sales and scores for that date. Essentially, I want the date filters to work one day, but not the other. Is this possible?
