Forum Discussion
CONCATENATE A PIVOT TABLE
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 .....
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]) )
2 Replies
- amitchandak
Super User
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]) )
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%.
