Problem with Pivot Table

[#1]

Hi,

     im having a problem to show some values in a pivot table. This is an example of what I want to do:

TABLE1:

Date	Number of Employees
01/01	50
15/01	55
04/02	60
12/02	58
16/02	55
05/03	45

I need to do a Pivot table that shows number of employees per month and days. The problem is that i dont know what expression to use to achieve this. If i look in days, expression [Number of Employees] works, but it doesnt work in month dimension. And it isn't possible to sum number of employees because i only need the last value of employees of every month (and even the same value in a possible year dimension).

It would be great if this can be solved without modifying the script.

Thanks for the help in advance.

[#2 · Accepted solution]

This worked for me:

firstsortedvalue ([Number of Employees],-Date)