CONCATENATE A PIVOT TABLE

[k1ko92]

Hi everyone,

Someone know how can i build this table concatenating all the information from column EVAL PENDIENTE, my unique key is the proyect (Proyecto)

PRUEBA LLENADO | DESARROLLO MONOGRAFIA | ENTREGA DE PLANOS | CREACION UPC | BRIEF LANZAMIENTO .....

[amitchandak · Accepted solution]

@k1ko92 , no very clear

a new table 

summarize(Table, Table[protect], "_concat" , concatenatex(Table,Table[EVAL PENDIENTE]," ,") ) 

or measure in visual

concatenatex(Table,Table[EVAL PENDIENTE]," ,")

or

calculate(concatenatex(Table,Table[EVAL PENDIENTE]," ,") , allexcept(Table, Table[protect]) )

[k1ko92]

Hi @amitchandak,

It worked :)))))))), just a new doubt, how can i insert a filter inside of that ?

Summarize

FILTER - I need to summarize just for projects that have 100%.