1.
Select Help > Sample Data Library and open Companies.jmp.
2.
Select Tables > Sort.
3.
Select Type and click By to assign Type as a sorting variable.
4.
Select Profits ($M) and click By.
Figure 1.39 Sort Ascending Icon
5.
To change Profits ($M) to sort in descending order, select Profits ($M) and click the descending button.
Figure 1.40 Change Profits to Descending
6.
Select the Replace Table check box.
When selected, the Replace Table option tells JMP to sort the original data table instead of creating a new table with the sorted values. This option is not available if there are any open report windows created from the original data table. Sorting a data table with open report windows might change how some of the data is displayed in the report window, especially in graphs.
7.

Help created on 10/11/2018