3 Replies Latest reply on Apr 13, 2016 5:39 PM by Nirupam Haas Tirukkovalluri

    Displaying Only 1 Group Membership

    Erin Gehn

      Hello~

      I have a set of data in the tabular form of Year, Month, ID(s).

      Filters on these ID(s) include state=IL, open year=2015, type=WC, and Group=A.

      Group A is defined by any subgroup containing the first 3 letters "WCI".

      Group B is defined by any subgroup containing the first 3 letters "WCM".

      There are 2 other groups that do not matter for this situation.

      An ID can be within multiple groups (for example, the ID can be in subgroup WCI and within subgroup WCM), so I would like to make another filter/field that states::

      If an ID exists within Group A, then that ID should not exist in Group B.

       

      Have you any ideas/suggestions/tips???