HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Performing On-Report Analysis with Web Intelligence (August 2008)

Organizing results on tables using breaks and sorts168
Note: You can apply multiple sorts to a table or section and then prioritize the sorts, so
that the information is sorted in the order you require. To do this, you need to set your
Reporting Rules so that Web Intelligence always makes the last sort you apply either (a)
take precedence over other sorts or (b) be the last sort to be applied after other sorts. For
full information on how to do this, see ”To define your reporting rules” on page 30.
Available sort orders
The following sort orders are available:
Note: To sort months in chronological order, apply the Default sort order.
Applying and removing sorts
You can apply sorts to any of the following types of data on tables or sections:
• dimensions - typically retrieve character-type data.
For example: customer names, line names, or dates.
Sort order Description
Default
This is sometimes referred to as the “natural” order.
Depending on the type of data in the column or row, the
results are sorted as follows:
• ascending numeric order for numeric data
• ascending chronological order for date
• alphabetical order for alphanumeric data
Ascending
When selected, results are arranged in ascending
order: The smallest value at the top of the column
moving to the highest value at the bottom.
For example: 100, 200, 300 or California, Colorado,
Florida.
Descending
When selected, results are arranged in descending
order: The highest value at the top of the column moving
to the smallest value at the bottom.
For example: 300, 200, 100 or Florida, Colorado,
California.
Custom When you define a custom sort, you choose your own
sort order for the data.