UPCOMING WEBINAR: From Thousands of Tables To One Clear Story: using AI in survey analysis This article describes how to go from a standard table...
...to a table where columns with values under a specified threshold (e.g. 10%) are replaced with text:
Requirements
A table with rows and columns.
Method
- Select your table.
- Go to Data > Rules > + > Cell Content > Replace Small Values with Text in the object inspector
.
- Select the statistic to base the condition on.
- Select the threshold.
- Enter the replacement text.
- Press OK.
Note, a footer (caption) note is also added, which specifies this condition.