I have grouped data by a primary key in this case a dispatch number. In that dispatch there are product types ie, parts/machines etc. However I am attempting to filter out the dispatches that have a mixture of types that I can define in that part type category.

For example, a dispatch that has both “machine” and then another line with “parts” in it. I would want to be identified. Where as if all of the dispatches where the lines were exclusively “parts” I would want them separated also.

I have attempted using the field that counts the lines in a dispatch in a loop but that fails in the formula editor. I was wondering if you could think of a simpler solution that I may be overlooking?