Qlik Sense - Bar Chart Question - Filter by Max Date

[#1]

Hello,

My database table is a salary history for employees, with a row for each salary change.

Example:

Employee Number     Salary Change Date     Salary

1                                   01/01/2001                    5

1                                   01/01/2002                    10

1                                   01/01/2003                    15

I would like to create a bar chart that displays the following:

Dimension: Employee Number

Measure: Sum of the Salary for the most recent "Salary Change Date"

Could someone point me in the right direction?

thanks,

Chris