Hi guys, let's suppose the following scenario.   Clientid       Purchase_Date         item_name               amount       1                     01/01/2020                book                        $20                    1                     01/01/2020                book                        $-20 2                     03/01/2020                pen                          $2 3                     04/01/2020                game                       $70 2                     03/01/2020                pen                          $-2 1                     06/01/2020                bike                         $200   Is possible to see that there is some negative values under the [amount] column, these refers to items returned to the store, and it's recorded as a negative purchase.   I would like to know how could I remove transactions (both positive and negative) for  items that returned to the store?   Notes: The orders returned have the same [Clientid], [Purchase_Date], [item_name], and [amount]                ... View more