Sort a list in text object by Dimension

[#1]

Hi,

I have a dimension that i sort in my graphics with another dimension. It allows to give specific order to the dimension. But i have to show this dimension in a report, so in a text box, and i don't find a way to sort it the like the dimension.

It should exist a formula like sort(dimension, field)... or i don't know.

Thanks for the help !

[jerem1234 · Accepted solution]

Not sure how you are displaying the Field in the text box. I would assume you are concatenating the field values. The concat function has a built in sorting mechanism if you use the third parameter like:

concat(Company, ',', [Company sequence])

or

concat(Company, ',', -[Company sequence])

Depends if you want ascending or descending.

Hope this helps!

[#3]

Damn that was quick !

Thanks a lot !