Hiding non-significant rows
If you have added a minimum p value column to a column proportions or column means test, you can hide rows based on the value in this column. This means that you can carry out a test on all the rows in the table and then hide any rows that contain no significant results, as determined by the minimum p value.
This enables you to carry out a test on all the rows in the table and then hide any rows that contain no significant results, as shown by the minimum p value.
Method 1
1 From the menu, choose Tables > Properties.
2 In the Hide tab of the Table Properties dialog box, select Hide rows.
3 In the list, select greater than.
4 Enter the significance level expressed as a percentage; for example, if you are using a significance level of 5, enter 0.05.
5 In the based on drop-down list, select variablename{MinPval}.
Method 2
Use the syntax:
Set R = TableDoc.Table1.Rules.AddNew()
R.Type = 0 ' hide
R.Target = 0 ' row
R.CellItemRef = 0 ' if cellitem 0 (counts)
R.Operator = 4 ' is greater than
R.Value = 0.10 ' required significance level
R.ElementRef = "variablename{MinPVal}" ' for MinPVal column
R.IgnoreSpecialElements = False ' hide special elements
See also