Data filtering enables the user to display in a table only the data that satisfies the specified conditions.
Data filtering in report columns is executed using the Filtering Settings button in column headers. To display the
Filtering Settings button, click the
Filtering button on the Home toolbar tab.
For the columns with values of the Data type, aggregation will be executed in the filter as the hierarchy: Year - Month - Day - Hour - Minute - Second:
One can select both elements and hierarchy levels. To quickly select the filtering element, use search. Enter the text in the search string. Search is executed automatically as the searched text is entered in the search string. The list will display only the elements, which names contain the entered text.
As a result of filtering application, all elements selected in the list formed from all values of filtered strings will be displayed in the table. For columns, for which the filtering is set up, the button will look like: .
To disable filtering:
Select the Clear Filter item for the column in the drop-down menu of the
Set Up Filtering button.
Release the Filtering button on the Home toolbar tab for all the columns.
When sorting and filtering are finished, follow the step if required:
See also: