Loading the most recent data of a resource field only

[#1]

I want to load only the most recent of a resource type, or create a button to click on that shows removes any repetitions and only shows the latest.

For example:

I have 10 staff data entries for each of the staff through their project life cycles,

I want to find only the latest project that each are on, or their finish date for the latest project.

I have staff ID

Projects start and end dates

I have tried loading a variety of Max(date) functions with no success.

Please help. Thank you in advance

[swuehl]

You can probably use FirstSortedValue() for this kind of request, for example in a chart with dimension staff

=FirstSortedValue( [Project Name], -[Project End Date])