Question

Filter on a dimension and use the result to filter another report

  • 3 January 2022
  • 0 replies
  • 7 views

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? 


0 replies

Be the first to reply!

Reply