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. To do this, you can 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
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.
See also