11 Replies Latest reply on Feb 11, 2017 4:34 AM by Simon Runc

    Creating Filter Based on Sets with Intersecting Data

    cameron.taylor.2

      Version: 9.3.1

      Packaged Workbook: Attached

       

      Challenge:

      First time poster, so please advise if I break etiquette. I have looked for the answer to this specific question to no avail, on and off these forums. I am attempting to create sets, and then create a filter off of those sets. The sets have intersecting members (one record can belong to multiple sets). I currently have a calculated field using IF statements which results in only the first IF statement claiming the intersecting members. I understand why it is not conceptually working – just not sure how to remedy it. I appreciate any insight you all may have.

       

      Workbook:

      Currently

      • Select “John’s Favorites” in the quick filter: Blue, Gold, Green, Mauve, Orange, and Purple
      • Select “Jane’s Favorites” in the quick filter: Red, Silver, Teal, Yellow

      Goal

      • Select “John’s Favorites” in the quick filter: Blue, Gold, Green, Mauve, Orange, and Purple
      • Select “Jane’s Favorites” in the quick filter: Orange, Purple, Red, Silver, Teal, Yellow