Hey Anusuya,

Currently there is no option to order dropdown items. Dropdown items is sorted by alphabetical order for string type columns.

One option would be to use a Button Dropdown (see image), where you set a variable to the filter condition you would like and then place either a sheet or analysis filter based on what it is you want to achieve. The downside of the Button Dropdown option is that you are not able to search for values, so for large amount op options it becomes less usefull and that the selected filter will not appear in your filter bar on the top of your analysis sheet.

Hope that helps,

Maurits