The 'Srt/Grp/Tot' column on the Business Intelligence|Results page enables you to define how to sort, group or total the results for the corresponding result member.
The following table describes the options available:
Function |
Description |
Ascending |
Sorts in ascending order (A to Z or 0 to 9). |
Ascending Grouped |
Sorts and groups in ascending order (A to Z or 0 to 9). By grouping, if there are multiple rows in the results with the same data, they will be grouped into one row. If you do not group those result members with a plus sign (+), result members can return more than one row. |
Descending |
Sorts in descending order (Z to A or 9 to 0) |
Descending Grouped |
Sorts and groups in descending order (Z to A or 9 to 0). By grouping, if there are multiple rows in the results with the same data, they will be grouped into one row. If you do not group those result members with a plus sign (+), result members can return more than one row. |
Sub-Total |
Sums the result member based on the grouped result member (Ascending Grouped or Descending Grouped). |
