Hello,
I'm trying to figure out a multi-step filtering logic for my data:
ID | Affected by | Type | Weight |
1 | A | inactive | 0.6 |
1 | B | active | 0.4 |
2 | C | inactive | 1 |
3 | A | inactive | 0.4 |
3 | B | active | 0.2 |
3 | D | active | 0.4 |
I would like to keep rows under the following criteria:
The resulting table should thus be:
ID | Affected by | Type | Weight |
1 | B | active | 0.4 |
2 | C | inactive | 1 |
3 | D | active | 0.4 |
Thank you for your help!
Solved! Go to Solution.
So simple but effective. Thank you!