The result set rows can be sorted according to one or more columns. Each column can be given a sort priority. For example, a column with priority 1 sorts before a column with priority 2. The measure cell chosen for drill-through always sorts with priority 0 (before the column with priority 1).
-
To define a sort priority for a column, select the appropriate column and enter a positive integer in the Sort Priority box, which lists the order that the columns sort in.
Entering a priority equal to an existing priority increments the priority created earliest. For example, if there was already a 1, 2, and 3, and the user entered 1 in a previously blank cell, then the original 1 becomes 2, the original 2 becomes 3, and so forth. The opposite happens if a number is removed; all other lower priority sorts decrement by one.
The priority is specified using positive integers less than 100, restricting the value to one or two digits. To enter a number, click in the cell and types, consistent with any other text box. To remove a priority, delete the numbers in the cell using backspace or delete.