Rank

Syntax:

Rank(Order, HierarchyOrder, GroupName)

Parameters:

• Order. Type: String. Contains expressions for ordering comma-separated group records. You can set the order direction by using the words Asc and Desc. You can add AutoOrder after the field, which means that the ordering fields defined for the referred object are used for ordering references. If the order is not specified, the value is calculated based on the grouping.
• HierarchyOrder. Type: String. Contains expressions for ordering hierarchical records.
• GroupName. Type: String. The name of the grouping where group processing is calculated. The calculation is performed in the current group if none is specified. If calculation is performed on a table and the parameter includes a null string or is blank, the value is calculated for the row grouping. When the data composition template is generated, the template composer replaces this name with the grouping name in the resulting template. If the grouping is not available, the function is replaced with NULL.

Example:

Rank("[Quantity Turnover]")