Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to create Table B from Table A
TABLE A | ||
Customer | Year | Sales |
A | 2015 | 1067 |
B | 2015 | 1037 |
C | 2015 | 1505 |
A | 2016 | 1431 |
B | 2016 | 1661 |
C | 2016 | 1429 |
A | 2017 | 1399 |
B | 2017 | 1121 |
C | 2017 | 1702 |
TABLE B | ||
Customer | Year of Max Sale | Val of Max Sale |
A | 2016 | 1431 |
B | 2016 | 1661 |
C | 2017 | 1702 |
Can anyone help me?
Thanks
Thank you for your help