This article describes how to go from a standard table...
..to a table where entire rows and/or columns have a sample size below a specified threshold are hidden:
Requirements
A table.
Method
- Select your table.
- Go to Data > Rule in the object inspector.
- To apply the rule, select Plus (+) > Modify Whole Table or Plot > Hide Rows and Columns with Small Sample Sizes.
- Specify the Minimum Sample Size.
- By default, both Hide Columns and Hide Rows are ticked but you can untick one of these if necessary.
- You can additionally set the statistic to use for hiding rows and columns independently.
- Choose the appropriate statistic for hiding each selected dimension.
- Press OK.