Sorting Values in Views

 Video

You can sort values in table, graph, pivot table, and trellis views. You can sort on members, measures, and rows (where you see sideways triangles). You cannot sort on page or section edges.

You can use many options to sort in views. For example, when you sort a column, you can select from the following options:

• Sort Ascending — Enables you to sort the values in the column by ascending order, as a first-level sort. For example, string values sort alphabetically A through Z, numbers sort lowest to highest, and dates sort earliest to latest.

• Sort Descending — Enables you to sort the values in the column by descending order, as a first-level sort.

• Add Ascending Sort — Specifies that an ascending sort for this column is added as another sort for the analysis.

• Add Descending Sort — Specifies that a descending sort for this column is added as another sort for the analysis.

• Clear Sort — Removes the sort specification for the specified column. This option works differently in the Selected Columns pane than in other places. If you make sort specifications in both the Selected Columns pane and in the view itself, then you return to the Selected Columns pane and click Clear Sort, only the sort that you specified in the Selected Columns pane is removed. A sort that you specified in the view remains.

• Clear All Sorts in All Columns — Removes all sort specifications that you have made. This option works differently in the Selected Columns pane than in other places, as described for Clear Sort.

For example, in a table in the Brand Revenue analysis, you can select an ascending sort on the Revenue column. Doing so sorts revenue values from the lowest to highest.

You can sort values in the following ways:

• Right-click in a view heading, click Sort Column, and select the appropriate option.

  
  Description of the illustration views02.gif
  
  

• From the Selected Columns pane of the Criteria tab, click Options beside a column, click Sort, and select the appropriate option.

  
  Description of the illustration views01.gif
  
  

You can also sort values in a view using the upwards and downward triangles that are found in column headings.

Description of the illustration views03.gif