Exclude rows that contain identical cells

Hello! I have a table that contains columns: Product ID, Customer name, Operation type (Sale or Refound).
Please tell me how can I exclude rows that contain Sales and Returns with the same Product ID?
For example when customer bought product (1 line) and when same customer returned product (2 line).

Product ID Customer name Operation type
12345678 Username1 Sale
12345678 Username1 Refound
87654321 Username2 Sale

You either do a Where clause in SQL or a Custom Expression in The GUI

Hi, thanks for your answer! Can you tell me which one Custom Expression exactly?

Have a look here Custom expressions :slight_smile:

1 Like