Apricot Results will sort a table by the left-most column by default.

This table is sorted by Record ID because it is the first column in the table.

This table is now sorted by Name after moving the column to the left.

You can also change the sort of the table by right-clicking in the column, selecting Sort, and choosing Ascending, Descending, or Advanced.

Now the table is sorted by Date of Birth_199 in Descending order.

Advanced Sorting

The advanced sorting option will let you choose a custom sort. Right click into the table > Select Sort > Advanced. You will see the Manage Sort window.
In this window, select Add under Sort: > Select the object you want to apply the custom sort to > OK

Once you have selected the object you want to sort by, select Values under Custom Order:

You'll open a window that shows all of the values for the selected object. Move the arrows up or down to change the position and select OK when you are done.


  • You can also access sorting by going to Analysis > Sort (you will need to have a column within the table highlighted for the option to be available)

Did this answer your question?