Hello,
I have the following table.
ITEM |
SUPPLIER |
DATE |
PRICE |
101642 |
47922 |
22/01/2020 |
5,4 |
101642 |
59368 |
02/07/2020 |
5,61 |
101642 |
59368 |
27/10/2020 |
5,61 |
101642 |
59368 |
05/11/2020 |
5,61 |
101642 |
59368 |
18/11/2020 |
5,61 |
101642 |
59368 |
28/11/2020 |
5,61 |
101642 |
59368 |
22/01/2021 |
5,61 |
101642 |
59368 |
23/01/2021 |
5,61 |
101642 |
46739 |
16/06/2021 |
5,05 |
101642 |
46739 |
17/06/2021 |
5,05 |
101642 |
59368 |
18/06/2021 |
5,26 |
101642 |
59368 |
22/10/2021 |
5,26 |
101642 |
59368 |
23/10/2021 |
5,26 |
With which way i can have the following table. I try with the aggr expression but i haven't the correct results.
ITEM |
SUPPLIER |
MIN DATE |
MIN PRICE |
MAX DATE |
MAX PRICE |
101642 |
46739 |
16/06/2021 |
5,05 |
17/06/2021 |
5,05 |
101642 |
47922 |
22/01/2020 |
5,4 |
22/01/2020 |
5,4 |
101642 |
59368 |
02/07/2020 |
5,61 |
23/10/2021 |
5,26 |
Can anyone help me ?
Thank you in advanced.