To sort data in ascending or descending order in a spreadsheet report:
In the navigation panel, select Data Sorting.
The data sorting settings are displayed in the properties panel. You specify data sorting criteria to affect the order in which the selected rows are retrieved in the data sorting panel.
From Dimension being sorted, select a row dimension.
The members in the row dimension are sorted according to the data values in a column. For example, you can sort members of the Product dimension based on their January sales data values.
In the data sorting panel, double-click (double-click to create a new sort rule).
From Ordering, select Ascending (to sort data values from lowest to highest) or Descending (to sort data values from highest to lowest).
From Column used for sort, select a member combination.
The member combinations listed here are determined by the members that you selected for the column dimensions. The data values for the specified column dimension members are used to determine the sort order for the members in the row dimension.
Next, you can rank the data, or apply the query now.
The values that you are ranking and sorting must be the same. For example, you cannot specify Product as Dimension being ranked and Market as Dimension being sorted. If you specify different values, Query Designer automatically changes both values to the last specified value. |
Applying Multiple Data Filters