Can anybody please clarify this issue?

[#1]

Position should come 1 2 3 4 5 in order wise and Others field should come bottom of the table (in last row)

[Anonymous]

Hi Arjun,

Go to Properties-->Sort-->Priority-->Promote 'Position' on top--> sort by:'Text' : A-Z --> Apply

Thanks,

[#3]

Yes it's working. Thank you so much friends for resolving this issue.

[engishfaque]

Hi Arjun,

Here is a expression for sorting as you want,

if(rank(sum(Votes))<Count([Candidate Name]), Sum(Votes))

Steps:

Chart Properties > Select Tab "Sort" > Select Column from Priority "Constituency" or "Candidate Name" > Checked to Check Box "Expression" > Paste Expression if(rank(sum(Votes))<Count([Candidate Name]), Sum(Votes)) > Select "Descending" from Drop Down > Apply > OK.

For more detail, please find see attached screenshot.

Kind regards,

Ishfaque Ahmed

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .