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

    How to Ignore Other Filter Criteria

    Jason Liau

      Hello,

       

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

      Table 1:

      [ID]

      [A-Date]

      [A-Count]

       

      Table 2:

      [ID]

      [B-Date]

      [B-Count]

       

      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!

       

      -Jason