Table Options

In Setup|Tables, select Table Options:

Summary rows:

WinCross automatically supplies the row text for the summary row. You can edit that text using Setup|Job Settings| Wording for Rows and specify where the summary rows should appear using Setup|Job Settings|Summary Rows.

Total

Show all cases in the data file, even those that have no data for the table.

Total Answering

Show any case that has data for the table, except those with no answers or missing data for the table.

Sigma

Multiple answers per case exist and you want the summary row to report the number of total responses for the table.

No Answer

Automatically include a ‘No Answer’ row as the last row of the table. A ‘No answer’ is defined as any case not accounted for by the rows of the table.

Frequency

Displays the number of cases for each ‘cell’ (intersection of a row and a banner column).

Vertical percent

Displays the percent of a cell based to the filter row total.

Horizontal percent

Displays the percent of a cell based to a banner column.

Constant percent

Displays the percent of a cell based to a constant (either a specified constant value or the intersection of a specified banner column and row (Total, Total Answering or Sigma). Specify the Constant value or Banner column and Row (Total, Total Answering or Sigma) intersection using Setup|Banners|Edit Banner|Horizontal/Constant Percents.

Hide blank rows

Hides rows without data.

Suppress weighting

Turn off weighting for a table.

Indent levels

Indents each level of netting. Indentation helps accentuate a table's nets and subnets. Indent levels works for net rows specified with the NET instruction and subtotal rows specified with the SUB instruction. You can also indent such rows manually by preceding row text with blanks.

• You have the option of selecting the number of spaces to indent for levels of netting.
• You can choose between 1 and 5 spaces from the dropdown menu.
• The WinCross default is 2 spaces.

Show percent sign (%)

Displays percent signs on all percents on the row.

Show dollar sign ($)

Displays dollar signs on tables with dollar values.

Show comma (,)

Displays commas for frequency cells.

Append next table

• Select Append next table if you want a table to print immediately after the previous table rather than start on a new page. You might want to use this option when you have two tables you want to appear together, but the rows in each table have very different options. You can set the tables up separately and append them.
• For the second table, use Hide filter within Filter in Setup|Tables.
• Additionally, use the same Table title you specified for the first table in Table title in Setup|Tables.

Frequency decimal places

• If you are weighting data, you can specify the number of decimal places you want reported.
• Select 0, 1, 2 or 3 from the dropdown list.
• Unweighted counts are always whole numbers.

Percent decimal places

• Specify the number of decimal places you want shown on all percents.
• Select 0, 1, 2 or 3 from the dropdown list.

Percentage Off

Subtitle

• Select Subtitle if you want to add extra text to the table title.
• You can enter up to 480 characters and will display on up to 4 lines.
• Text automatically wraps, but you can specify where the text will wrap by entering multiple lines in the Subtitle window. Pipe symbols (|) are inserted in the subtitle for that table in the job file (View|Job File) automatically when multiple lines are entered. Keep in mind that regardless of how many characters you enter on each line, text will wrap based on the Table title width specified on the Table Presentation tab of Setup|Job Settings for Plain Text Reports or on the Enhanced Text Reports tab of Setup|Job Settings for Enhanced Text Reports. For example, if you enter 50 characters on the first line and 50 characters on the second line and your table title width is set at 40, the text will wrap at 40 characters from the first line and then wrap again after the remaining 10 characters, then wrap at 40 characters from the second line and again for the remaining 10 characters of the second line, resulting in 4 lines of row text. Alternatively, you can specify where words should break by inserting a pipe symbol (|) at the point where you want the break to occur.
• The Subtitle appears below the Table title, wherever the Table title appears on the page.
• If you want a blank line displayed between the Table title and the Subtitle, enter a vertical bar (|) at the beginning of the subtitle.

Footnote

• Select Footnote if you want a footnote to appear on the bottom of each page of the table.
• A footnote can have up to 480 characters and will display on up to 4 lines.
• Text automatically wraps, but you can specify where the text will wrap by entering multiple lines in the Footnote window. Pipe symbols (|) are inserted in the footnote for that table in the job file (View|Job File) automatically when multiple lines are entered. Keep in mind that regardless of how many characters you enter on each line, text will wrap based on the Table title width specified on the Table Presentation tab of Setup|Job Settings for Plain Text Reports or on the Enhanced Text Reports tab of Setup|Job Settings for Enhanced Text Reports.For example, if you enter 50 characters on the first line and 50 characters on the second line and your table title width is set at 40, the text will wrap at 40 characters from the first line and then wrap again after the remaining 10 characters, then wrap at 40 characters from the second line and again for the remaining 10 characters of the second line, resulting in 4 lines of row text. Alternatively, you can specify where words should break by inserting a pipe symbol (|) at the point where you want the break to occur.
• Alternatively, you can use the vertical bar (|) to indicate where you want text to break.

Ranking options:

• Select Rank to specify ranking for a table.
• Ranking can be based on frequencies, percents, means or by a previous table. If you choose ranking you must specify whether you want to rank By frequencies/means, By percents/means or By a previous table.
• When ranking By a previous table, choose the table to use as the ranking table. Both tables need to have similar structures including the same number of rows. Row text can be different, but it is up to the user to choose the appropriate table as the ranking table.
• If you select By frequencies/means or By percents/means,you must specify the Order for ranking, choose either Descending or Ascending order.
• Rows that are hidden using the Hide row option of Setup|Tables|Row Options are not included in ranking and will not be assigned a rank number when using the Show rank number in all cells option.

In most cases, ranking by frequencies and percents achieves the same results. However, when a table's rows have different bases, the results of ranking by percent can be quite different than those of ranking by frequencies.

If the table is composed of mean summaries, the table is ranked automatically by means.

When ranking is selected on a table with nets or subtotals, the items within the net or subtotal are ranked if the NET or SUB instructions are used to specify the rows. If several nets or subtotals appear on a table with ranking, they are ranked within each net or subtotal and then ranked overall. To force an entire net or subtotal to rank high or low, choose Row Options in Setup|Tables and select the row with the NET or SUB logic. Then choose Ranking and specify High, Low or Neither, let rank determine.

Row(s) can be excluded from ranking within the table. See the If ranking, force row to rank option of Row Options for more information on excluding rows from ranking.

Show rank number in all cells

Choose Show rank number in all cells if you want the rank number to be printed in all cells.

Related topics:

 Setup|Tables