Table Filter

Every table created must have a filter (filter is used interchangeably with base). The filter is the set of qualifications that must be met for a case to be included in the table. The filter is typically shown as a table's first row. The filter row reports the counts for the cases that qualify for each of the banner columns.

To specify the filter row for a table, choose the Filter option on the Setup Tables dialog box.

Filter type:

Total

If you choose Total and don't enter additional filter logic, all cases in the data file are included, even those that have no data for the table.

Total answering

If you choose Total answering and don't enter additional filter logic, all cases in the data file are included. ‘No answers’ are included on the table, but they aren't in the filter so they are not included in percents.

Sigma

Choose Sigma when multiple answers per case exist and you want the filter row to report the number of total responses for the specific variable being tabulated.

Net Total (Indexed)

If you are using Indexed Variables and want a filter row that is respondents and not responses, use the Net Total (Indexed) option. If you choose Net Total (Indexed) and don't enter additional filter logic, all cases in the data file are included, even those that have no data for the table.

Rows to exclude from:

Rows to exclude from lets you specify rows to exclude from Total Answering and Sigma.
Select Total Answering or Sigma and the dialog box displays the available rows.
If Total answering is the table filter, excluded rows are represented with a 'TX' in the WinCross job file (View|Job File) and are not included in the percent.
Excluded rows from Sigma are represented with a 'GX' in the WinCross job file (View|Job File).

Filter title

Filter title text is supplied automatically when you choose a filter type. You can edit this text in any way you like.
Filter titles can have up to 480 characters on up to 4 lines when the Filter title is printed under the table title. Text automatically wraps, but you can specify where the text will wrap by entering multiple lines in the Filter title window. Pipe symbols (|) are inserted in the filter title 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 and then wrap again at the end of the first line, 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.
When the Filter title is printed on the filter row, the number of lines depends on the Row text width specified in Setup|Job Settings|Table Presentation (for Plain Text Reports) or the Row Text column width specified in Setup|Banners (for Enhanced Text Reports). You can specify where the text will wrap by entering multiple lines in the Filter title dialog. Pipe symbols (|) are inserted in the filter title of 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 row text width. For example, if you enter 50 characters on the first line and 50 characters on the second line and your row text width is set at 40, the text will wrap at 40 characters and then wrap again at the end of the first line, 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.
If you want the same filter title to appear on all of your tables, you can specify that text in Setup|Job Settings|Wording for Rows.
You can override the Filter title for any table by editing the automatically-supplied text.

Filter logic

The code ‘TN’ is supplied automatically for all filter types. You can overwrite this code with any other logic you want to use for your filter. Filter logic is identical to table and banner logic.

You can use one or more of the following items to further customize your table:

Frequency

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

Vertical percent

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

Horizontal percent

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

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 filter

The filter row does not display or print on your table.

Show percent sign (%)

Displays a percent sign on percents for the filter row.

If weighted, show unweighted filter

Displays the unweighted filter when tables are weighted.

If weighted, show effective sample size used for statistics

Creates a row on your table to display the effective sample size used when calculating Z-scores for significance testing for proportions (percents) when tables are weighted.

Volumetric filter

If your table uses volumetric data (such as the number of cars owned or total employees) you can choose Volumetric filter to have the filter row show total volume, rather than the count of cases. See Volumetric Tables for additional information.

Filter title options:

Show filter title under table title

Displays the filter title text under the table title. The text for the actual filter will also appear on the filter row (for example, ‘TOTAL ANSWERING’). When you choose this option, the filter title also appears in the report table of contents.

Show filter title on filter row

Displays the filter text on the filter row, the first row of the table.