HP Storage Essentials Storage Resource Management Report Optimizer Software 6.0 Building Reports Using the Web Intelligence Java Report Panel (August 2008)

Building Reports Using the Web Intelligence Java Report Panel 321
Look at the following table:
Notice that the figures in the Min by Year column are the same as those in the block
footers in the example ”Specifying an output context” on page 319, even though this
block contains an additional dimension, Month. This is because the formula for Min by
Year explicitly excludes Month from the input context. The formula looks like this:
Min ([Sales Revenue] In ([Year];[Quarter])) In ([Year])
This formula tells Web Intelligence to ignore month and calculate revenues by year and
quarter (the input context), then output the smallest of these revenues for each year (the