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

Creating custom calculations322
output context). If you had not explicitly specified the input context, the table would look
like this:
In this case, the input context is now (Year, Quarter, Month), so Web Intelligence
calculates revenues by year, quarter and month before outputting the smallest revenue that
occurs in the Sales Revenue column for each year. For example, 173,756.40 is the
smallest value that appears in the Sales Revenue column in 2001, so this value appears
in the Min by Year column in all rows where the year is 2001.
What would happen if you changed output context of the formula to (Year, Quarter)? The
formula now calculates revenues by year, quarter and month (the input context), but the