• 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?