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
