Forum Discussion

k1ko92's avatar
k1ko92
Regular Visitor
4 years ago
Solved

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 MONOGRAF...
  • amitchandak's avatar
    amitchandak
    4 years ago

    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]) )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
k1ko92
Regular Visitor
4 years ago

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%.