Reports: Data area: Filtering

To work with the tool in Foresight Analytics Platform 10, use the new interface.

Setting Up Filtering

Parameters for filtering rows and columns of the data area are the same, but are determined on separate tabs.

NOTE. Empty elements are filtered before calculation, but positions are reserved for the elements not linked to the dimension.

To set up filtering parameters, go to the Filtering > Rows/Columns tab of the Data Area Properties dialog box. The dialog box looks as follows:

If the Hide Empty Values checkbox is selected, all empty rows or columns of data area are hidden. An empty row (column) is a row (column) that does not contain any data element.

If the Hide Zero Values checkbox is selected, all rows or columns of data area that contain only zero values are hidden.

If the Hide Non-Numeric Values checkbox is selected, all rows or columns of data area that contain only non-numeric values are hidden.

If the Hide Values on Condition checkbox is selected, the Expression box is available, enter filtering condition to this box. The VALUE variable is used on forming a filtering condition. This variable determines cell contents. For example, with the condition VALUE>100, all the data area rows (columns) that contain values greater than 100 are hidden.

Filtering conditions can be entered:

Manually. Enter a condition in the input box.
Using the expression editor. To run the expression editor, click the button.

If the Determine Elements Excluded from Filtering Conditions checkbox is selected, the Dimension Elements hierarchical list is available. In the list select the elements to be skipped when filtering. If the row or column slice contains several dimensions, the list shows only elements of the last dimension.

NOTE. If the Display Owners Of Non-Excluded Rows (or Columns) and the Use Stairs Hierarchy checkboxes are selected on the Layout tab, on applying any filter only those child elements that have some data are shown for the owners of non-excluded rows.

A dimension-determined filtering can be set up when setting up data area filtering.