tejapowerbi
New Member
- Joined
- Nov 30, 2018
- Messages
- 19
Hello,
I want to remove receipts no which have opposite values (Y vs N,1 vs -1 etc.).if each receipt's row has opposite row. I.e. if also will be row 500.2 (with any content) - receipt 500 will not be removed.
<tbody>
</tbody>
I want to remove receipts no which have opposite values (Y vs N,1 vs -1 etc.).if each receipt's row has opposite row. I.e. if also will be row 500.2 (with any content) - receipt 500 will not be removed.
Receipt No | Indicator | Count | Rate | Region ID | |
500 | N | 1 | 100 | 11 | |
600 | N | 1 | 200 | 12 | |
601 | N | 1 | 300 | 13 | |
500.1 | Y | -1 | -100 | -11 | |
603 | N | 1 | 400 | 14 | |
Final Result | |||||
Receipt No | Indicator | Count | Rate | Region ID | Comments |
500 | N | 1 | 100 | 11 | Remove |
500.1 | Y | -1 | -100 | -11 | Remove |
600 | N | 1 | 200 | 12 | Keep |
601.1 | N | 1 | 300 | 13 | Keep |
603.2 | N | 1 | 400 | 14 | Keep |
<tbody>
</tbody>