Good day
I need help filtering data based on results of another visual
DATA (GOOGLE DRIVE LINK)
I have a set of data that shows all sales of products
Attached LINK
I than use the filter by list by devscope filter to see only my promotion sales
what i see: attached LINK (1st visual)
Now the second part is where i need help...
I create a new visual on the same canvas to show sales and i edit interaction between the visual and filter by list so that the new visual is not affected.
I now see all sales whether promotional or not, i need help filtering that data in the new visual to show only the invoices in which the customers bought promotional items which is as per the table above as well as where they added normal products to the same basket, where there is a sale of a non promo item only for an invoice i dont want to see that invoice. so essentially what i want to see in the second visual is when customers purchased promo items, what other items did they add to their cart.
sample of what i want to see: attached LINK 2nd visual
