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 where the primary statistic for the table is always 0% or NaN in at least one row or column. The primary statistic is the first statistic on the Statistics - Cells menu.
- 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.