Exclude rows that contain identical cells

Get Help
1

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
2

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

3

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

4

Have a look here Custom expressions :slight_smile:

1 Like