Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a table like this
Rsc | Date | Avialabel | ProduktA | ProduktB |
1 | 01.04.2022 | 60% | Yes | |
1 | 02.04.2022 | 30% | Yes | |
1 | 03.04.2022 | 60% | Yes | |
2 | 01.04.2022 | 30% | Yes | |
2 | 02.04.2022 | 60% | Yes | |
2 | 03.04.2022 | 60% | Yes | |
3 | 01.04.2022 | 40% | Yes | Yes |
3 | 02.04.2022 | 60% | Yes | Yes |
3 | 03.04.2022 | 60% | Yes | Yes |
4 | 01.04.2022 | 60% | Yes | |
4 | 02.04.2022 | 60% | Yes | |
4 | 03.04.2022 | 60% | Yes |
Now I need a 2nd. Table with all products.
Only with first date avialabel ist 60% or higher in all Rsc need per product.
Product | Availabe min |
ProduktA | 03.04.2022 |
ProduktB |
02.04.2022 |
Can anyone help me?
Thx
Greetings
No one with an idea? 🙂