3.1. Create Table - Single Table Selection
3.2. Create Table - Multiple Tables Selection
3.4. Export & Email Table
3.3.1. Customise Table - Display Functions
This function allows you to customise the display of the data table created. You could pivot the table, remove rows/columns from display, sort the data table using the table columns, or freeze panes for easy reference.
Partial Display

Step 1 of 4
In the Table Customisation and Chart Plotting page, click on the Display menu.
Display

Step 2 of 4
In the dropdown menu, click on Partial Display

Partial Display

Note: The Partial Display option will be greyed out if this function is not available for use in the table created.


Step 3 of 4
The Partial Display popup will display the full table. You may select/deselect the rows/columns you wish to show/hide by holding down Shift or Ctrl and Click on the time periods [1] or the variables names [2]. To select/deselect all columns, click the Select all button [3]. To select/deselect all rows, click the Select all button [4].
Popup

Step 4 of 4
Click on OK [5] to apply the changes and display the resultant table. Click on Cancel [6] to undo all changes. The original table will be displayed.

Result

To reselect the rows/columns or show the original table, click on "Partial Display" again and reselect accordingly. Back to top
Pivot (Available for Single Table Selection Only)

Step 1 of 3
In the Table Customisation and Chart Plotting page, click on the Display menu.
Display

Step 2 of 3
In the dropdown menu, click on Partial Display

Pivot

Note: The Pivot option will be greyed out if this function is not available for use in the table created.


Step 3 of 3
The resultant table will be displayed.

Result

Note: You can return the table to its original format by performing another pivot action.
Back to top
Custom Sort (Available for Single Table Selection Only)

Step 1 of 5
In the Table Customisation and Chart Plotting page, click on the Display menu.
Display

Step 2 of 5
In the dropdown menu, click on Partial Display

Pivot
Note: The Custom Sort option will be greyed out if this function is not available for use in the table created.


Step 3 of 5
The Custom Sort popup will be displayed.

Popup

Note:

- You can only sort the table by the column variables. By default, the variable name and each time period will be listed for selection.
Column List

- If pivot is performed on the table first, the time variable and the variable names will be listed for selection.
Column List

- For VARIABLE NAME column, the sort options are: A to Z, Z to A.

- For TIME column, the sort options are: Newest to Oldest, Oldest to Newest.

- For all other columns, the available sort options are: Smallest to Largest, Largest to Smallest.

- To perform more than one level of search, click on the Add Level button [1]. Once a column has been selected, you will not be able to select it for new levels added.

Column List

- To remove a sort level, simply click on the Remove hyperlink [2].


Step 4 of 5
Choose a variable to sort under the Column name drop-down list.

Step 5 of 5
Choose the order you want the chosen variable to be displayed under the Sort order drop–down list.


Back to top
Freeze

Step 1 of 3
In the Table Customisation and Chart Plotting page, click on the Display menu.
Display

Step 2 of 3
In the dropdown menu, click on Screenshot_40
Screenshot_6


Step 3 of 3
The first column of the data table and the row containing the time period will now be fixed when you scroll horizontally and vertically.

Popup

The Screenshot_40 is changed to Screenshot_41. Click on "Unfreeze" if you wish to remove the static column and row.

Back to top