Brio Software
Technical Publications
Home Previous Next Index Glossary
Data Analysis and Reporting with Intelligence Clients

Limiting Data in a Table

Limiting data in a table filters the data displayed in the table columns. You can apply Limits in the Table section in addition to any limits set in the originating section. Limits set in the Table section are automatically propagated to any other reports that inherit their data set from the table. You can apply only one limit per column.

To return data to the display and make it available for reporting, delete or suspend the limit.

To limit data in a table:

  1. Double-click the column in which you want to place a limit, or select a column (click the column heading) and choose Table then Limit.
  2. The Limit dialog box appears.

  3. Select an arithmetic or logical operator from the drop-down list.
  4. Define the potential limit values by clicking one of the following options:
    • Show Values – Shows column values associated with the item.
    • Custom Values – Supplies an empty field for inputting custom values. Click the check mark to add a value to the list.
  5. In the Values list, select the values to include in the limit definition.
  6. Individually select values or click Select All and deselect the values you do not want to include.

  7. When the values are highlighted in the values panel, click OK.
  8. The limit is applied to the column and the column name is added to the Limit line.

To remove a limit in a table, select the limit and do one of the following:

To remove all limits in a table, click Limit on the Limit line and do one of the following:

Home  |  Previous |  Next  |  Index |  Glossary

Privacy/Legal | Copyright 2002 Brio Software, Inc.