Operation Manual

Creating and Updating OLAP Reports
Adding calculations to OLAP grids
19
382 Crystal Reports User’s Guide
Filtering data in an OLAP grid
Use filters to exclude grid data that are not important, or to display only the
data that you want to see. You can filter grid data by actual values, or you can
choose to exclude or display the top or bottom N, or the top or bottom N%.
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.
u
To add a filter
1. Right-click the field whose values you want to filter.
2. On the shortcut menu, click Add Filter.
3. In the Define Filter dialog box, use the Filter Type list to specify how you
want to filter the data.
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.
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.