Working with Table Data

Data sorting and filtering in columns on a report sheet is executed by means of the

Filtering Settings button in column headers.

Select the range, for which sorting or filtering should be executed.

NOTE. The first non-empty row of the selected range is the row with column headers. Sorting and filtering of values in each column starts with the second non-empty row of the selected range.

Click the Filter button on the toolbar. The Filtering Settings button is displayed in all columns of the selected range.

NOTE. Only one filter is available on one sheet. If filter is already enabled on the report sheet, selecting a new range and clicking the Filter button will hide the Filtering Settings button set for the first range.

Select any table cells with data.

Click the Filter button on the toolbar. The Filtering Settings button will be displayed in all table columns event if only one cell was selected.

Release the Filter button on the toolbar. The Filtering Settings button will be hidden in all column on the report sheet, the set filtering will be disabled.

Sort

Range sorting enables the user to quickly sort the selected range of regular report sheet.

Click the Filtering Settings button in the column header.
Select the sorting method:

. Ascending.
. Descending.

When the sorting is enabled, sorting direction is displayed in the corresponding column header.

The selected range values are sorted by the first column.

Filter

Filtering is a method of finding a data subset and working with this data in the list. A filtered list shows only the rows that meet the conditions set for the given column. The rows that do not meet the filter condition, are hidden.

To filter single columns of a range or a table on a report sheet:

Click the Filtering Settings button in the column header.

Set up filtering method. The following standard autofilter operations are available:

Clear Filter. The operation is used to display all rows.
Top N. The operation is used to display the specified number of list elements. The number of elements is specified either directly or in percentage of total amount of filtered elements:

The following options can be determined in this dialog box:

Number of Rows. The edit box that is used to specify the number of displayed rows.
Attribute. It determines whether least or greatest elements are displayed.
Selection Condition. It determines how the number of elements is specified - directly or in percentage of the number of elements.

NOTE. This filter will not be available if there are no numeric values in filtered rows.

Set Up Filter. The operation that is used to determine filtering conditions in the Custom Autofilter dialog box:

The following options can be determined in this dialog box:

Selection Condition. The drop-down list that determines the condition for displaying elements (equal, not equal…).
Value. The drop-down list that determines the condition value for displaying elements. This list of elements includes all values of autofilter range sorted without taking the case into account. The case is taken into account only when the values match.
Filtering conditions. This radio button determines the order of using two conditions at the same time. There are two options of use of condition combinations:

AND. When the radio button is selected, the rows satisfying the both conditions are displayed.

OR. When the radio button is selected, the rows satisfying at least one condition are displayed.

To filter data in all table columns on a report sheet:

Select a table cell.
Click the Parameter. Make sure that the Table element is selected in the drop-down list on the parameters panel.
Click the Filtering element.

The following filtering options are available:

Keep Owners of Non-Excluded Elements. Parent elements of non-excluded rows or columns will not be hidden.
Hide Empty Cells. The table rows and columns that contain no data will be hidden.
Hide Cells with Zero Values. The table rows or columns that contain zero values will be hidden.
Hide Cells with Non-Numeric Values. The table rows and columns that contain only non-numeric values will be hidden.
Hide by Condition. The rows or columns are hidden, which cell data corresponds to the condition specified in the drop-down list. Most of the conditions use one or two numbers to match with cell result:

Equal to A.
Not Equal to A.
Greater than A.
Less than A.
Greater or Equal to A.
Less or Equal to A.
Between A and B.
Less than A or Greater than B.
Expression.

To set a complex formula, use the Expression option.

Editing and Saving

Saving Changed Data in Source

To save report data:

Click the Save > Save Report Data on the toolbar.
Select the Data > Save Data > Save Report Data main menu item.

As a result, changed data of all report tables will be saved.

Saving changed report data is available if at least one report table has:

Changed values.
The Save Data to Source checkbox selected.
Changed values and the Save Data to Source checkbox selected.

To save sheet data:

Click the Save > Save Sheet Data button on the toolbar.
Select the Data > Save Data > Save Sheet Data main menu item.

As a result, changed data of all active sheet tables will be saved.

Saving changed sheet data is available if at least one sheet table has:

Changed values.
The Save Data to Source checkbox selected.
Changed values and the Save Data to Source checkbox selected.

Changed data can be saved to the following types of sources: standard cube, cube view, virtual cube, modelling variables.

When saving report, if changed data was not saved, it is prompted to save them. After the confirmation report data will be saved.

Working with Table Data

Sorting and Filtering

Sort

Filter

Editing and Saving

Saving Changed Data in Source