Hi,
I want to remove Positive and Negative entries basis Sales Number, From & To location and fetch Unique Bill number rows.
Weight Bill number Date Sales number Bill type From To
50 11112222 19-06-2022 123456 Invoice Pune Mumbai
-50 22223333 22-06-2022 123456 Cancel invoice Pune Mumbai
40 33334444 25-06-2022 123456 Invoice Pune Mumbai
60 55556666 30-06-2022 123456 Invoice Pune Mumbai
Output should be as below,
Weight Bill number Date Sales number Bill type From To
40 33334444 25-06-2022 123456 Invoice Pune Mumbai
60 55556666 30-06-2022 123456 Invoice Pune Mumbai
Can someone help here.
Regards,
Samir