Profile Settings|Filters

Note: Changes made to Profile Settings only apply to "new" jobs created using the modified profile and will have no effect on "existing" job files. Use Setup|Job Settings or Setup|Globally Modify Tables to make changes to existing job files.

In Setup|Profile Settings, you can specify table filter settings using the Filters tab.

Filter type

Choose the filter type for all tables.
Total - includes all cases in the data, even those that have no data for the table.
Total answering includes all cases in the data (with no additional filter logic). 'No answers' are included on the table, but are not included in the filter so they are not percentaged.
Sigma - reports the number of total responses for the specific field/variable being tabulated when multiple answers per case exist.

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

Filter options

Show filter row - displays the filter row on your table.
Show filter title on filter row - displays the filter text on the filter row, the first row of the table.
Show filter title below table title - displays the filter text under the table title. The text for the actual filter will also appear on the filter rows (e.g. 'TOTAL ANSWERING'). When this option is selected, the filter title also appears in the report table of contents.
Center table filter title - centers the filter title when displayed below the table title.
Show frequency on filter row - displays the number of cases for each cell (a 'cell' is the intersection of a row and a banner column).
Show vertical percent on filter row - displays the percent of a cell based to the banner column total.
Show horizontal percent on filter row - displays the percent of a cell based to the row total.
Show constant percent on filter row - 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.
Show percent sign (%) on filter row - displays a percent sign on percents for the filter row.

Note: These filter options also appear on the Profile Settings|Table Presentation tab. Changing these options on either tab automatically changes them on the other tab.