Sorting Data in Visualizer
Sort data in a report using Sort in the Chart Builder. Measures can sort ascending or descending. Attributes sort alphabetically or reverse-alphabetically.
To change the way data is sorted
| 1.
|
Add the attributes
and measures you need to create your chart. For example, Units in Stock
by Country.
 |
| 2.
|
To sort, in
the Chart Builder drag a column and drop it on Sort. For example, to sort
by UnitsInStock, drag UnitsInStock from Measures to Sort. Important: Sorts do not take effect by dragging a column
from the Subject Area to Sort. You must use a column that is already in the Chart Builder. To hide a column see Adding Tooltips and Hiding Columns.
 |
| 3.
|
Visualizer
sorts the measure or category (attribute) according to its default sort criteria.
For example, UnitsInStock sorts from lowest to highest.
 |
| 4.
|
You can change
the type of sort to apply. Visualizer provides sort options in the Subject
Area. |
| 5.
|
You can add
additional columns to Sort. Tip: When sorting on two measures where one is an expression, the sort on the expression takes precedence. This is because expressions are sorted at mid-tier whereas basic columns are sorted at the database level.
|
| 6.
|
Click Save
. |
Learn More
Visualizer
Report Basics
Working
with Chart Reports
Working
with Tabular Reports