Hiding a row or column
You can hide rows or columns in your tables where the values are equal to, above, or below a value that you specify.
To hide rows or columns
1 In the Tables pane, select the table that you want to modify.
2 Click Tables > Properties.
4 Select Hide rows or Hide columns 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.
To hide columns, you select the row on which to hide, and vice versa.
5 In the 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.
6 Click OK to close the Table Properties dialog, save your changes, and apply them to the current table.
7 Generate the table to see the results of your changes: click the Generate table button
.
To base the hide condition on a different row or column
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 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 list.
See also