Create a conditional Set on Order ID that has the formula:
SUM(IF [Product Name] = 'A' THEN 1 ELSE 0 END) > 0
The Set will return a boolean IN/OUT and can be used as a Column C, a dimension, in calculations, etc.
But this will assign 'In' value to, in this case, for Order ID 1234 which I don't want. The product mix for any id should only be Product A. If it has other products then it should assign out.
1 of 1 people found this helpful
You can still use a Set, there are a variety of ways of writing this. Assuming that Product Name is never Null, this will work:
MIN([Product Name]) = 'A' AND MAX([Product Name]) = 'A'
Oh you are a genius ! Thanks a ton. It worked