Select highest value only for duplicate rows

Content

I have a table of data in OTBI but some employees have duplicate rows. This is because they have 2 different values in a certain column. For these employees, how can I select only the row which contains the highest value so that I only return one row per employee? The MAX formula on the value column does not work.

Below is an example what I am trying to achieve:

Original table:

ID	Value
1	100
2	150
2	200
3	130
4	400
4	300

Required output:

ID	Value
1	100
2	200
3	130
4	400

 

Thanks!