Sorting Data in a Graph

Sort Ascending or Descending Values in a Graph

Right-click the name of a category or hierarchy level in a graph, and then select either Sort Ascending or Sort Descending.
To specify a sort order for values in a graph, complete these steps:
  1. Right-click the name of a category or hierarchy level in a graph to sort the category or hierarchy level by the values of the measure used in the graph.
  2. If the graph has more than one measure, you can choose which one to sort by.
Before Sorting: A Bar Chart
Before Sorting: A Bar Chart
After Sorting: The Same Bar Chart with the Continent Category Sorted in Descending Order
After Sorting: The Same Bar Chart with the Continent Category Sorted in Descending Order

Sort by Measure Values in a Graph

Right-click the name of a category or hierarchy level in a graph to sort the category or hierarchy level by the values of the measure used in the graph.
To specify a sort order for values in a graph, complete these steps:
  1. Right-click the name of a category or hierarchy level in a graph to sort the category or hierarchy level by the values of the measure used in the graph. If the graph has more than one measure, you can choose which one to sort by.
  2. To sort by measure values in a graph based on a multidimensional data source, select either Sort Ascending by <column-name> or Sort Descending by <column-name>, where <column-name> is the name of the column that you selected. For example, in the following display, the Sort Descending by Total Sales Summary option was selected.
    Bar Chart with the Sort Descending by Total Sales Summary Menu Item Selected
    Bar Chart with the Sort Descending by Total Sales Summary Menu Item Selected
    After Sorting: The Same Bar Chart with the Continent Category Sorted in Descending Order by Total Sales Summary
    After Sorting: The Same Bar Chart with the Continent Category Sorted in Descending Order by Total Sales Summary
Copyright © SAS Institute Inc. All rights reserved.