Sort (Macro Command)
This macro command will sort the rows of data in a Parametric or Lookup table. The format is:
SORT TableName ColumnName Rows=1..10 Order=Ascending/Descending Applyto=All/ThisColumn
TableName must be the first parameter. This is the name that appears in the tab of the Parametric or Lookup table. It can be a string constant (withing single quotes) or a previously defined string variable.
ColumnName must be the second parameter. This is the name that appears in the header cell of the column that is to be sorted in the Parametric or Lookup table. It can be a string constant (withing single quotes) or a previously defined string variable.
All following parameters are optional.
Rows=1..10 specifies the range of rows for which the sort will be applied. The first and last rows can be integers or previously defined EES variables. If the rows are not provided, the first and last row in the table will be used.
Order=Ascending/Descending indicates if the sort will result in ascending or descending values. If this parameter is not provided, the order will be ascending.
Applyto=All/ThisColumn indicates whether just the specified column or all columns are repositioned. If not provided, Applyto will be set to All.