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

Creating custom calculations328
Sum ([Sales Revenue]) In Section
The figure in the Section Total column is the total revenue for 2001, because the section
break occurs on the Year object. Without the Section keyword this column would
duplicate the figures in the Sales revenue column, because it would use the default
output context ([Year];[Quarter]).
For more information on default contexts, see ”Default calculation contexts” on page 314.
The Break keyword
The following table describes the dimensions referenced by the Break keyword
depending on where it is placed in a report:
Example: The Break keyword
You have a report showing Year, Quarter and Sales revenue. The report has break
on Year. The Break Total column has the formula:
Sum ([Sales Revenue]) In Break
When placed in... References this data...
A block Data in the part of a block delimited by a
break.
A block break (header
or footer)
Data in the part of a block delimited by a
break.
A section (header,
footer, or outside a
block)
Not applicable.
Outside any blocks or
sections in the report
Not applicable.