Sorting on report

[samadam]

I am trying to sort a report but does not work properly. I am grouping the report on a field which is a dropdown. I want NO to appear last with other values first which are alphabetically before N but still NO shoes up first. Any idea hoe to fix? I tried to change sort order, sequence on the choices as well but no luck

[Robert H]

Hello @samadam ,

Please let us know what kind of report you are building (e.g. a time series report, or a bar chart, etc.) and provide a screen shot of how it's currently configured and the output.

Without that information it's hard to suggest something.

Regards,

Robert

[Vishal Jaswal]

Hello @samadam 

I believe the way it works is based upon the count of total records (highest to appear in the beginning and lowest at the end). May be a HI Case and seeking something from ServiceNow can help