How to Hide Non-Significant Rows and Columns

This article describes how go from a table like this which shows all the rows whether or not they have any significant results. 

... to a table like this which hides the rows with no significant results.   

This rule will hide any rows or columns in the table which do not have any significant results. The significance is evaluated by checking the Corrected p statistic against a set level that you can change by editing the rule. You can choose to hide rows, or columns, or both.

Requirements

A crosstab table with significance testing.

Method

1. Select the crosstab table
2. In the Object Inspector, select Data > Rules > Modify Whole Table or Plot > Hide Non-Significant Rows and Columns
3. In the New formatting rule dialog, you can choose to hide non-significant rows, or columns, or both. The significance is evaluated by checking the Corrected p statistic against a set level that you can change by editing the rule.
   
   
   
4. Click OK
   The results are as follows.

Next

How to Hide Uninteresting Data