Hi, Jorge. Use function concat(). Which takes 3 parameters. In your case, you would write something like this: concat(distinct [resource name],',',[resource name])
The above assumes you want to order the concatenation alphabetically. If you need to use a different order, change the 3rd parameter.
Thanks Vlad, it works.
I use this function as an expression in the pivot table: concat([resource name],', ', [Job Name])
but I needed the new field as a dimencion so I use this code
Concat(Nombre_Recurso,', ',Nombre_Tarea) as Union
group by Nombre_Tarea;
and it worked well, thanks for your help !!!!