No...
So my problem it's that the pivot function needs an aggregate function to work, but what i need it's the current field value...
In this case it could be anything, some cases it can be a date,or a text, or even a integer (id), it really depends in the job type.
Can this be done by the pivot function, or i need to create some memory table to try do the job?