Working with Table Data

1. Select:

• Any table cell:

• Sheet range that should be sorted or filtered:

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.

2. Click the Filter button on the Home toolbar tab. The Filtering Settings button is shown:

• For all table columns:

•  For all columns of the selected sheet 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.

Release the Filter button on the Home toolbar tab. The Filtering Settings button is hidden in all columns:

• The sorting and filtering configured for a data range on the report sheet is disabled.

•  The configured data filtering in the table is disabled.

To sort data on a report sheet:

1. Click the Filtering Settings button in the column header.

2.  Select the sorting method:

• . Ascending.

• . Descending.

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

The selected range values are sorted by the first column.

To filter data in a data range on a report sheet or in a table:

1. Select data range on the report sheet or a table cell.

2. Click the Filtering button on the toolbar. Cell range headers or table heading headers display the Filtering Settings buttons.

3. Click the Filtering Settings button or select the column header cell and press ALT+DOWN:

For the columns with values of the Data type, their selections will be aggregated in the filter as the hierarchy: Year - Month - Day - Hour - Minute - Second:

4. Specify necessary values in the list or 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. When the operation is selected, the Condition by List dialog box opens:

The following parameters can be set 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 parameters can be set 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 combining conditions: AND - when the radio button is selected, the rows that satisfy both conditions will be displayed; OR - when the radio button is selected, the rows that satisfy at least one of two conditions will be displayed.

5. Select the checkbox next to the element, by which filtering will be executed. Multiple selection is available.

NOTE. For the columns containing value of the Date type 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 while the searched text is entered into the search string. The list will display only the elements, which names contain the entered text.

After filtering is applied, the table/columns will display all elements selected in the list formed from all values of filtered rows. For columns, for which filtering is set up, the button will look like: .

To disable column filtering, select the Clear Filter item for the column in the drop-down menu of the Set Up Filtering button.

To save report data:

• Click the   Save Data > Save Report Data button on the Home or Data toolbar tab.

• 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 is selected.

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

To save sheet data:

• Click the Save Data > Save Sheet Data button on the Home or Data toolbar tab.

• Select the Data > Save Data > Save Sheet Data main menu item.

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

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

• Changed values.

• The Save Data to Source checkbox is selected.

• Changed values and the Save Data to Source checkbox is selected.

To undo report data changes, click the button:

• Undo Changes on the Home or Data toolbar tab.

• Undo Changes > Report on the Home or Data toolbar tab.

As a result, data changes of all report tables are undone.

To undo sheet data changes, click the Undo Changes > Sheet button on the Home or Data toolbar tab. As a result, data changes of all active sheet tables are undone.

Undoing of data changes is available if at least one table contains changed data.