Segment Creation

There's essentially two ways to make a segment that doesn't include a particular product, and depending on what you want it to return will decide which method you use. I'll start by saying, you have to identify a specific product (or products) in the segment.

First, if you want to return a hit that contains something other than the product in question (whether or not the product is also present)

"Product does not equal X"

Doing this at a hit level will return any hit that contains a product that is not X. Now, if a hit contains two products (X and Y), it will still return that hit, because the "not X" condition is met, so it will return the whole hit. An example of this would be if someone places an order and buys more than one product. 

Second, if you want to exclude any hit that contains the product, regardless of what else is in it.

"Product equals X" inside of an Exclude container

Doing this will exclude any hit that contains X product, regardless of what else is in the hit. So take our example of an order with two products, X and Y. That hit would not be included here because of the presence of X (so it can possibly undercount other products).

Unfortunately, due to the complications of how Products works, the segment:

Hit

    Product equals X

    AND

    Product does not equals Y

    And

    Online Order exists

Won't result in the expected outcome... 

For example:

Scenario 1 (only Product X":

Scenario 2 (Product X and Product Y):

Scenario 3 (Product X and Product Z):

The segment above will return Scenario 1 and Scenario 3, it will not return Scenario 2 (despite Product X being included), and the segment will also return the Product Z from Scenario 3....

So your Product X will be missing "Product X" hits, and still including other products that you don't want... 

This is because the logic of segments on products runs the logic on each individual product, but pulls back all products that were part of the same hit...

Unfortunately, applying filters onto the table is the most reliable way to see only Product X (unless you also have unique categories on your products... (see your other post).

But if you are trying to get back all products from "Department 1", and you are passing the departments as the category (or as a merchandising eVar, or maybe as a classification); you can pull that department value into the table as a locked top level breakdown, then break that down with "Products" allowing them to flow based on the locked item above them.