Stat-Xplore : Working With Tables - Totals, Percentages, Sorting and Codes

This section describes some of the options available when working with tables. It is assumed that you have already read the guide to getting started and you know how to login to Stat-Xplore and create a basic table by dragging and dropping fields or selecting the values you want and using the Add buttons.

Totals

Stat-Xplore automatically adds totals to tables, but you can choose whether to show totals. To show or hide totals, click the menu icon Menu icon vertical ellipsis next to the field name:

In some cases, it may not make sense for a total on certain fields (for example, a time series on a caseload dataset). In this case, we have configured a setting that prevents you from adding a total for that particular field.

Percentages

Use the option at the top of the table area to change the values in the table to percentages:

Percentages visible in table

You can choose from the following options:

Option	Description
None	Do not show percentages.
Column	Replace the values in the table with a percentage of the total in each column.
Row	Replace the values in the table with a percentage of the total in each row.

Some of the percentage options are not available for certain types of table.

Percentages are also not supported when opening a saved system table that was originally created in a ready-made table and that contains grand totals generated by that ready-made table.

Sorting

Click the arrows to sort the table:

Use the arrows in the column headings to sort the table based on the values in that column:

Sorted with gender descending

Use the arrows shown against the row field name to sort the table based on the row labels:

Sorted with gender ascending

In both cases, your first click will sort the column or row in ascending order, your second click will sort it in descending order, and your third click will revert back to the default sort order.

Codes

By default, the field labels show the names of the values (such as Male and Female). Select the Codes option from the field menu to display the field codes instead:

This is particularly useful for the unique geographical codes as these can be used to conjunction with other software for mapping and GIS.

Automatically Retrieving Data

By default, whenever you change the fields in the table, you need to click Retrieve Data to run the cross tabulation and display the values.

To avoid the need to click Retrieve Data, you can select the Automatically Retrieve Data option:

Selecting Automatically Retrieve Data
option

When this option is activated, Stat-Xplore automatically performs the cross tabulation whenever you change the table.

For performance reasons you may find it better to leave this option turned off, particularly if you are working with large tables.