This article describes how to go from a standard table...
...to a table where cells with a value under a specified threshold (e.g., 10%) are made blank:
Method
- Select your table.
- In the toolbar, go to Automate > Browse Online Library > Modify Cell Content > Blank Cells with Small Values.
- Select the appropriate statistic (if different to the default) to base the condition on.
- Select the appropriate threshold under Minimum Value.
- By default, Also set values of statistic to NaN is ticked to set blank cells to NaN.
- Press OK.
Note, a footer note is also added, which specifies this condition.
Next
How to Hide Rows Below a Specified Value