Sort Sets in the Opposite Axis by Value

You can sort members in the sets on the opposite axis based on the value of a member or measure that you select.

For example, a crosstab contains years inserted as individual members in the columns, product lines inserted as a member set in the rows, and revenue as the measure. You select the 2012 column and then select Sort by Value, Descending. The values in the 2012 column are sorted.

Figure 1. Crosstab showing revenue by year by product line with the 2012 column sorted in descending order
a crosstab showing revenue by year byshowing product line with the 2012 column sorted in descending order

Before you can perform this sorting, you must create sets for the members in your report.

In nested crosstabs, items are sorted based on the values of the innermost nested row or column of the opposite axis. For example, a crosstab contains years in the columns and retailers nested within product line in the rows. Select 2012, sort in descending order, and you see retailers listed from the largest value to the smallest value for each product line.

Procedure

  1. In a crosstab, select a member or measure to sort.

    For example, to sort a set in the row axis, select a member or measure in the column axis.

  2. In the report object toolbar, click the sort button sort icon and under Sort by Value, click Ascending or Descending.
    Tip: To remove a sort order, click Don't Sort.