3 Replies Latest reply: Oct 4, 2016 6:59 PM by Sunny Talwar RSS

    Set analysis with two selections

    michael Carson

      I am looking to setup a table that will display information based on multiple selections. It also needs to show the ENTIRE record, so long as that record includes the selection.

       

       

       

      AccountNumberGroupCodeReasonCodeAmount
      12345CO241
      12345PR12
      12345CO173
      99999CO274
      99999PR15

       

       

      My goal is to select CO, 24 and then also include accounts that have the PR GroupCode and 1 as a ReasonCode.

      I would expect that AccountNumber 12345 comes back and it does not just show the CO 24 and PR 1 but also shows the other CO 17 listed under that account.

       

      When i use:

      $<AccountNumber=P(AccountNumber), ReasonCode =, GroupCode= >}Amount

       

      I get it partially, although when i make the selections i want, it looks for anyone who has a GroupCode of CO AND PR AND it is reason code 24 AND 1