HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)
Ranking Data234
• sorts the records in ascending order
• works through the records until 40% of the total number of records are displayed
Example: Rank the top regions whose cumulative revenue is less than or equal to
10,000,000
To perform this ranking you set the following parameters:
This ranking gives the following result:
To calculate this ranking, Web Intelligence:
• sorts the records in descending order
• works through the records until it reaches the record that causes the the cumulative total
of the measure to pass 10,000,000
• includes those records that do not cause the cumulative total to pass 10,000,000
Example: Rank the bottom regions whose cumulative revenue is less than or equal to
30% of the total revenue
To perform this ranking you set the following parameters:
Parameter Value
Top/Bottom Top
n/n% 10,000,000
For Each Region
Based on Revenue
Calculation mode Cumulative sum
Region Revenue
Central 5,000,000
North West 4,000,000
Parameter Value
Top/Bottom Bottom
n/n% 30%
For Each Region