How can I order based on a specific sequence? In my view I have the following items: - X1 - X2 - X17
The order in the view is being displayed as: - X1 - X17 - X2
How can I force the first type of sequence?
3
-
What is the column type of Section field?– Ganesh Sanap - MVPCommented May 5, 2019 at 7:56
-
It is a single line of text– fonsiCommented May 5, 2019 at 7:58
-
2Then you cannot sort on single line of text like you wanted... However you can add one more number field "order" and sort on that column.– Ganesh Sanap - MVPCommented May 5, 2019 at 8:47
Add a comment
|
1 Answer
Add leading zeros: X01-05, X01-12, X02-01, X17-01
If you don't want to change the data, add a calculated column that inserts the leading zeros and sort on it, but don't display it.
answered May 6, 2019 at 0:15
