My database table is a salary history for employees, with a row for each salary change.
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?