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 or Descending in the Report Element Data panel.

Now the table is sorted by DOB in Descending order.

Custom Sorting

The custom sorting option will let you choose a custom sort. Create your sort in the Report Element Data panel > Click on the 3 circles next to the name of that sort > Select Create Custom Order.
In this window, select Add under Sort: > Select the object you want to apply the custom sort to > OK

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. Or add your own values to the list.

How do I sort columns in a Results report | How do I change table sort order in Apricot Results | How do I sort a report by a specific column | How do I create a custom sort in a report | How do I apply ascending or descending order in a report | How do I move columns to change sort order | How do I manually reorder values in a report sort