Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
cloud
Contributor III
Contributor III

Sort dimension that has integer and alphanumeric values

hi, 

I have a 'no. of month' dimension. it has values ranging from integers to alphanumeric eg. 5,1,7,6, < 1 Month

How do I sort such that '7' is at the top, descending all the way till '1' and '< 1 Month' is at the bottom below '1' 

any help is appreciated! thanks. 

Labels (4)
2 Replies
Claudiu_Anghelescu
Specialist
Specialist

Sort -> Expression->

=match(only({1} [no. of month]), '7','6','5','1','<1')
To help community find solutions, please don't forget to mark as correct.
cloud
Contributor III
Contributor III
Author

hi claudiu,

I'm looking for an dynamic expression instead of static input. thank you.