Space-Time Research Documentation

SuperSTAR 9 Documentation : Working With Tables - Totals, Percentages, Sorting and Codes - SuperWEB2

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 SuperWEB2 and create a basic table by dragging and dropping fields or selecting the values you want and using the Add buttons.

Totals

SuperWEB2 can automatically add totals to tables. Click the Totals icon on the field name to show or hide the total for that field:

In some cases, it may not make sense to add totals for certain fields (for example, a time series database). In this case, your administrator may have configured a setting in the SXV4 database that prevents you from adding a total for a particular field. If this is the case, the Totals icon will not appear on the field name.

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:

OptionDescriptionExample
NoneDo not show percentages.
ColumnReplace the values in the table with a percentage of the total in each column.
RowReplace the values in the table with a percentage of the total in each row.
Total

Replace the values with a percentage of the grand total.

If you are using wafers then this will show the total percentage across all the wafers.

Some of the percentage options are not available for certain types of table. For example, the Total percentage option is not available when the table contains multiple summation options.

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

Sorting

Click the arrows to sort the table:

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

Use the arrows shown against the row field name to sort 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 Single, Married, Divorced, etc). Click the Codes icon to display the field codes instead:

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, SuperWEB2 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.

Attachments: