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 209
In this example you have a report showing Year and Sales Revenue. Your data provider
also contains the Quarter object but you do not include this dimension in the block.
Instead, you want to include an additional column to show the maximum revenue by
quarter in each year. Your report looks like this:
You can see where the values in the Max Quarterly Revenue column come from by
examining this block alongside a block that includes the Quarter dimension:
The Max Quarterly Revenue column shows the highest quarterly revenue in each year. For
example, Q4 has the highest revenue in 2002, so the Max Quarterly Revenue shows
Q4 revenue on the row showing 2002.
Using the In operator, the formula for Max Quarterly Revenue is
Max ([Sales Revenue] In ([Year];[Quarter])) In ([Year]).
This formula tells Web Intelligence to calculate the maximum sales revenue for each
(Year,Quarter) combination, then output this figure by year.
Note: Because the default output context of the block is Year, you do not need to specify
the output context explicitly in this formula.