Custom sort list box

[#1]

Hi,

I have a list box created with an expression =[Product ID] & ' - ' & [Product Description] that has values like

001 - abc

123 - bcs

234 - 276

I want to sort the list box by the product Description in ascending order. Kindly suggest!

Thanks!

[sunny_talwar]

May be try a sort expression like this

Only({1} [Product Description])

and select ascending

[#3]

Did not work

[sunny_talwar]

Would you be able to share a sample where this isn't working?

[#5]

I have attached a sample.

[vishsaggi]

Can you do like

= ProductDescription & '-' & [Product ID]

Then Sort tab -> Check Text - A-Z.

Will that work?

[#7]

Does not work

[sunny_talwar · Accepted solution]

Try this

Rank(Only({1} [ProductDescription]))

With Descending sort

[#9]

Thank you Sunny. This is correct!

[vishsaggi]

Thanks Sunny, its been long go I have used something like Rank in sort. Thanks for refreshing memory. 🙂