More information about cell contents
See
To define cell contents for a table
1 In the Table List, select the table whose cell contents you want to define.
2 Select the Preferences tab.
The cell contents that have already been defined for a table are listed at the top of the Preferences tab. They are listed in the order in which they will appear in the cells of the table.
3 To add new cell contents, or reorder or delete the existing cell contents, click the Modify button.
The Modify Cell Items dialog opens: see
Modify Cell Items dialog.
4 Define the required types of cell contents and their order, and then click OK.
5 For each type of cell contents, select the number of decimal places and the other options your require. For more information, see
Defining cell contents.
To apply weighting to a table
1 In the Table List, select the table to which you want to apply weighting, and then click the Preferences tab.
2 From the list in the Weighted Table section, select the variable that you want to use to weight the table. In a hierarchical data set, you cannot populate a table containing variables at a higher level than the level of the weighting variable.
You can apply all of the options selected on the Preferences tab (including the weighting) to all new tables by choosing Set as default from the menu at the top of the Preferences tab.
You can apply all of the options selected on the Preferences tab (including the weighting) to all existing tables by choosing Apply to all tables from the menu at the top of the Preferences tab.
See also
To set percentage options
1 Click the
View Table tab, and then click the
Options button
The View Table Options dialog opens. See
View Table Options dialog.
2 In the Percentage Display Options section, you can:
▪Clear Display percent signs to remove percent signs from all percentage values in the table.
▪Select Show 100% in base rows/columns to display 100% in the base row or column.
▪Select
Adjust rounding so that percentages add up to 100% if you want UNICOM Intelligence Reporter - Survey Tabulation to change any rounding anomalies in row and column percentages so that they add up to 100%. For more information, see
Rounding values.
3 In the Zero Values section, enter the characters that you want to use for percentage values that are zero and rounded to zero.
4 Click OK.
To set the characters to be displayed for zero values
1 Select the
View Table tab, and then click the
Options button
The View Table Options dialog opens. See
View Table Options dialog.
2 In the Zero Values section, enter the characters that you want to use for counts, percentage values, and other values that are zero and rounded to zero.
3 Click OK.
These options apply to all your tables. You will need to repopulate your tables before the changes are applied.
To sort a table on a row or column
You can sort tables by the values in a row or column.
1 In the Table List, select the table you want to sort, and then click the Preferences tab.
2 In the Sorting section, select the row or column on which to sort the table from the Row Sorting or Column Sorting list.
You can sort tables on both rows and columns. For more information, see
Sorting rows and columns.
To suppress rows or columns
You can suppress rows or columns where the values for the base count are zero or below a value that you specify.
1 In the Table List, select the table, and then click the Preferences tab.
2 In the Suppress Columns or Rows section, click Suppress columns with base counts below or Suppress rows with base counts below.
3 If required, enter a value below which to suppress the rows or columns. The default is zero.
4 Repopulate the table to see the results of your changes.
See also