This article describes how to go from a table or chart with entire rows and/or columns of 0% or missing data...
..to a table where these empty rows and/or columns are removed:
Requirements
- A table or chart with at least one empty row or column
- Note that this rule is not compatible with R-based visualizations created via Create > Charts > Visualization.
Method
- Select your table or chart.
- In the toolbar, go to Automate > Browse Online Library > Modify Whole Table or Plot > Hide Empty Columns, Hide Empty Rows, or Hide Empty Rows and Columns.
- Press OK.
A note is added to the footer when any rows or columns have been removed.