UPCOMING WEBINAR: DIY Data Cleaning & Prep: Super Fast, Super Good Register now >>

How to Replace Small Values in Tables With Text

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.

Select your table.
Go to Data > Rules in the object inspector.
To apply the rule, select + > Modify Cell Content > Replace Small Values with Text.
Select the statistic to base the condition on.
Select the threshold.
Enter the replacement text.
Press OK.

Note, a footer note is also added which specifies this condition.