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Ā
next to the field name:
![Gender total hidden](attachments/57802819/60719155.png)
![Gender total visible](attachments/57802819/60719154.png)
Percentages
Use the option at the top of the table area to change the values in the table to percentages:
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. |
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:
Use the arrows shown against the row field name to sort the table based on the row labels:
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:
![Showing field labels](attachments/57802819/60719266.png)
![Showing field codes](attachments/57802819/60719265.png)
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:
When this option is activated, Stat-Xplore automatically performs the cross tabulation whenever you change the table.
Attachments:
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)
![](images/icons/bullet_blue.gif)