Omit missing data
You can omit rows or columns of entirely missing data. Zeroes do not count as missing values.
To omit missing data:
-
On the
Dimensions tab, in the
Data group, from the
list,
select:
Option Description Missing By Row This option hides all rows with no data from the view. Missing By Column This option hides all columns with no data from the view. Missing By Both Hides all columns and rows with no data from the view. None This option restores any columns or rows with no data previously hidden from the view. - Click .