HP Intelligent Management Center Standard Software Platform - Manual (Page 504)

You can filter data by "Actual values," or by selecting "Top/bottom n" or
"Top/bottom n%."
4. Use the Filter Definition options to specify which rows or columns you
want to exclude or display.
5. Click OK to add the filter and return to the OLAP grid.
Tip:
• To locate a filtered row or column, move the mouse pointer over the OLAP
grid. When you reach a filtered row or column, the pointer turns into an
X.
• If you filter all the cells in your OLAP grid, right-click the empty grid and
select Remove All Filters from the shortcut menu.
Search the online help for "Filtering data" in the "Using the OLAP Worksheet"
section to learn more about filtering.
Adding calculations to OLAP grids
Calculated members enable you to perform specific calculations on OLAP
data and to display the results in rows or columns that are added to the OLAP
grid. You can create a quick calculation, such as a Variance member
calculated by subtracting Budget from Sales. Or you can use functions to
perform complex Statistical Analysis or Time Series calculations.
Search the online help for "Adding calculated members" in the "Using the
OLAP Worksheet" section to learn more about calculated members.
504 Crystal Reports 2008 SP3 User's Guide
Creating and Updating OLAP Reports 19
Adding calculations to OLAP grids