Hello I have to create a report where I need to find all the items in a transaction other than the filtered item.
So for example
I have an Item number 1 which is sold in TRANSACTION #1 and #3. These transactions will have other items as well like for example,
Transaction #1 could have Item 2, Item 3 and Item 1
Transaction #2 could have Item 2 and Item 4
Transaction #3 could have Item 2, Item 3 and Item 1
When I filter on Item 1 I want to see all the other items in transaction #1 ,#2 and #3 other than Item Number 1
So my output if I filter on Item 1 should be Item 2 and Item 3 because these items are sold in the same transaction where item 1 is also present. Related Item Selling.
Is there a way in looker where I could filter on a dimension which would give me results of another dimension and then use this resulted dimension to create another report?