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
