4 Replies Latest reply: May 15, 2015 2:37 AM by Jonathan Dienst RSS

    How to Ignore Other Filter Criteria



      I have a several tables with date fields that link together by ID:

      Table 1:





      Table 2:





      When I make selections on date fields separately, it works fine.

      A-Date = 2014 returns A-Count or

      B-Date = 2014 returns B-Count


      But if I make selections on multiple date fields, i.e.

      A-Date = 2014 and B-Date = 2014

      it only shows me a subset of A-Count and B-Count for records that have the same ID


      How would I approach this issue if it is necessary to keep the ID link? Is the best solution to use set analysis to ignore field selections? Thanks!