Function Concat in dimension

[suzel404]

Hi all

How can I obtain values not in line:

Example : Concat(DISTINCT Name&' '&LastName&' '&PostaleCode, chr(10)

I want :

Name LastName PostaCode

Name LastName PostCode

NameLastName PostalCode

Thank you for your help.

[#2]

Why dont you just try a calculated dimension:

=Name&' '&LastName&' '&PostaleCode

or you use a straigt table with the 3 dimensions and then you have everything right next to each other.

regards,

MT

[Anonymous]

Try this:

Name & ''& LastName & '' & PostaCode

[tresesco]

Try:

=Concat(DISTINCT Name&' '&LastName&' '&PostaleCode )

[#5]

why yould you need a concat for this??

[tresesco · Accepted solution]

Concat() would be required to handle a lot of records. That is, if you want this to work in place like text box/variable; with such scope where there would be more than one records - this aggregation function would be required. Hope this clarifies.

[suzel404]

Thank but I woulf like the previous range and forward range in dimension.
I can obtain it in expression But  not in dimension.

How can obtain it in dimension.  

[suzel404]

I use valueList (StartEnd).

Thank.