Hello
I would like to add a filter that both values need to be met to populate data. so in my screen shot 000001896 would be ignored because the STOP_SEQ is just 1, but 000001895 has STOP_SEQ 1 and STOP_SEQ 2 so I would like to only see 000001895 populate along with both stops. How would I go about doing this?
I tried STOP_SEQ IN ('1') and STOP_SEQ in ('2') which didn't show errors, but it didn't work.
shipment STOP_SEQ FACILITY
000001896 1 100
000001895 1 200
000001895 2 300
STOP_SEQ IN ('1') and STOP_SEQ in ('2') returns 0 results, right? You can't have two different values in the same column on one row, so both conditions can't be met. It's like saying FRUIT = 'APPLE' AND FRUIT = 'BANANA'. It can't be both.
If you want to show only the shipments that has more than one STOP_SEQ:
count (distinct [STOP_SEQ] for [shipment]) > 1