Next
You can hide rows, columns, or cells in your tables where all values are equal to, above, or below a value that you specify. This means that you can display tables without rows or columns containing insignificant values. For example, the following table contains both a row and a column that contain only zero values:
By hiding rows and columns containing only zeros, you can simplify the table and display only the information of interest:
By default, all values in the first cell item in a row or column must be equal to zero for that row or column to be hidden, as in the above example. However, you can use the value in another row or column on the table to test the hide condition. For example, in the following table of interest by age, a column has been added to show the mean age:
If you are interested in the results for a particular age range, you can hide rows where the mean age column has a value of greater than 30:
