How to concat data

Paknanarn23 — Wed, 03 Jul 2024 02:38:41 GMT

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?

Re: How to concat data

Lech_Miszkiewicz — Wed, 03 Jul 2024 03:03:05 GMT

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