Specifying the number of grids and applying filters

Use this tab to limit the records that are returned, and specify the number of grids that are required.

The Filter area determines the boundaries that will be placed on your report. For example, if you have a time dimension that is made up of fiscal quarter fields, you could specify the report return the results for a specific quarter.

Note:    If all of your fields were used in the Rows/Column tab nothing will appear here.

The Page area enables you to determine the number of grids and the subject of each. For example, if you have a product dimension, you could put this in the page area and specify two different products. This would result in two grids with the same rows, columns, and formatting, but each one would be based on a different product.

Specify a filter

1. Click the field picker to determine the field that is going to be used as the filter.

   The Select Fields for Dimension dialog box appears.

2. Select the appropriate field, expanding the structure if necessary.
3. Click OK.
4. Click Next if you do not want to add a page.

   The Style tab appears.

Add a page

1. Drag and drop the dimension(s) into the page area.

   The Select Fields for Dimension dialog box appears.

2. Expand the dimensions structure and select the appropriate fields.
3. Click OK.
4. Click Next.

   The Style tab appears.