Next
You can hide rows or columns in your tables where the values are equal to, above, or below a value that you specify.
► In the Tables pane, select the table that you want to modify.
► From the menu, choose:
► Choose the Hide tab.
► Check the Hide rows or Hide columns box as appropriate. Alternatively, choose one of the First/last row/column options. These options are useful if you add new categories to your surveys over time and you want to reuse the tables. For example, if you have a table containing monthly data, you can select Last column to hide rows based on the value of the last month, rather than selecting the name of the month each time you update the data.
If required, you can hide both rows and columns.
Note: To hide columns, you select the row on which to hide, and vice versa.
► In the drop-down list, select the condition for hiding the row or column, and enter a value. For example, you might choose to hide rows where the values are less than 10. The default condition hides values less than or equal to zero.
► Choose OK to close the Table Properties dialog box, save your changes, and apply them to the current table.
► Generate the table to see the results of your changes:
► In the Hide tab, you can specify a different column or row to test the hide condition. Select the row or column from the based on drop-down list. For example, to hide all rows that have a value of less than 30 in the mean column of a variable called age, select age{eMean} from the drop-down list.