I am trying to work out if it is possible to build a segment in work space to return the where a product Y was sold for more than EUR 0. Every single order on our site contains two or more products, the first (Product X - which should be noted is in a different category) is always chargeable, the second (Product Y) is chargeable around 50% of the time.
Annoyingly if I build a hit level segment that contains Product Y exists and Revenue > 0, all orders are returned because on that same hit Product X has revenue.
Are these answers useful? Help other community members by marking useful answers as accepted.