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

Performing On-Report Analysis with Web Intelligence 171
NOTE: You can also define a custom sort from the Sort Properties dialog box by
clicking Custom Sort, which takes you to the Custom Sort dialog box.
Defining multiple sorts
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.
About breaks
A break is a division in a table that groups data with the same results.
Example: How can I show revenue subtotals for each state in a table?
The table on the left displays sales revenue per year per state, with the total sales revenue
result displayed at the bottom of the table. The table on the right displays the same data,
but with a break on “State.” In this table, the results for each state are grouped together.
This means you can now show a subtotal for the revenue generated by each state.
Inserting breaks in tables enables you to:
• organize how information is presented, by grouping related information together
• display subtotals for each group of information
How data is sorted when you insert a break
When you insert a break on a dimension, the values for the dimension are automatically
sorted in ascending order. If the values are numeric, the lowest value appears in the first
row of the table and the highest result appears in the last row. If the values are