How to concat data

[Paknanarn23]

Need to concat data for column 1 as shown in the picture.

I tried this code  Concat({<Column = {'Column 1'}>} SUM_ReMark, chr(10))
But the results were reversed. What should I do?

[Lech_Miszkiewicz]

Remove Concat_Row column from the chart and use

• Concat([Column 1],',') assuming that Column 1 is the name of the filed you are trying to concatenate 
• If you wish to list only distinct values then use Concat(Distinct [Column 1],',')
• If your [Column 1] is a measure then the epression would need to take into account dimensionality of the chart (dimensions) and it would be somithing like:
  • Concat(Aggr("your measure expression",Dim1,Dim2,Dim3),',')
    • your measure expression could be whatever is producing Column 1: for example Sum(Sales)
    • Dim1, Dim2, Dim3 etc.. are the dimensions which drive granularity of your required concatenation

cheers