Filter after multiple selection

[#1]

Hi guys,

I have a table containing the purchase detail. Every row has a purchase order ID (header info) and its related purchase item.

Let's assume the table is like this.

PurchaseOrderID     PurchaseItem

1                              A

1                              B

2                              C

3                              C

3                              D

Is it possible to get the below result after I select item A and D?

PurchaseOrderID     PurchaseItem     Reason

1                              A                      Because it matches with A

1                              B                      Because it relates to PurchaseID=1

3                              C                      Because it relates to PurchaseID=3

3                              D                      Because it matches with D

Thanks in advance.

Roy

[sunny_talwar · Accepted solution]

May be a set analysis like this

{<PurchaseOrderID = p({<PurchaseItem = p(PurchaseItem)>} PurchaseOrderID), PurchaseItem>}

[#3]

Hi Sunny,

Thank you for the help, it worked!!