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.
| AccountNumber | GroupCode | ReasonCode | Amount |
|---|
| 12345 | CO | 24 | 1 |
| 12345 | PR | 1 | 2 |
| 12345 | CO | 17 | 3 |
| 99999 | CO | 27 | 4 |
| 99999 | PR | 1 | 5 |
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
