Survey Tabulation > Cell contents > General "How to" information
 
General "How to" information
See
To define cell contents for a table
To apply weighting to a table
To set percentage options
To set the characters to be displayed for zero values
To sort a table on a row or column
To suppress rows or columns
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 that is just above the list of cell contents.
The Modify Cell Items dialog box opens. See Modify Cell Items dialog box.
4 Use the features in the Modify Cell Items dialog box to define the required types of cell contents and their order.
5 Click OK.
This returns you to the Preferences tab.
6 For each type of cell contents, select the number of decimal places and, when relevant, the other options your require. See Defining cell contents for more information.
To apply weighting to a table
1 In the Table List, select the table to which you want to apply weighting.
2 Select the Preferences tab.
3 From the list in the Weighted Table section, select the variable that you want to use to weight the table. Note that in a hierarchical data set, you cannot populate a table containing variables at a higher level than the level of the weighting variable.
Tips
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
Weighting
Weighted data
Displaying an effective base on a weighted table
To set percentage options
1 Select the View Table tab.
2 From the View Table toolbar, choose the Options button
The View Table Options dialog box opens. See View Table Options dialog box.
3 In the Percentage Display Options section, you can:
Deselect 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 adjust any rounding anomalies in row and column percentages so that they add up to 100%. See Rounding values for more information.
4 In the Zero Values section, enter the characters that you want to use for percentage values that are zero and rounded to zero.
5 Click OK.
To set the characters to be displayed for zero values
1 Select the View Table tab.
2 From the View Table toolbar, choose the Options button
The View Table Options dialog box opens. See View Table Options dialog box.
3 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.
4 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.
2 Select the Preferences tab.
3 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. See Sorting rows and columns for more information.
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.
2 Select the Preferences tab.
3 In the Suppress Columns or Rows section, check the Suppress columns with base counts below or Suppress rows with base counts below box.
4 If required, enter a value below which to suppress the rows or columns. The default is zero.
5 Repopulate the table to see the results of your changes.
See also
Cell contents