Table Filter (Express Table Editor)

You can add a Filter to your table on the Table Editor tab of Setup|Express Tables from Variable Data.

Filter title

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.

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 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(s) being tabulated.