How to Hide Zero-Value Rows In A Pivot Table

How to Hide Zero-Value Rows In A Pivot Table

Easily hide zero value rows in a Pivot Table


Hiding the rows that contain zero values in a Pivot Table is a common need that many people struggle with. There is a surprisingly simple (but not so obvious) solution.

From the Pivot Table Field List, drag the field that contains zero values from the ‘Choose fields to add to report’ section down to the Report Filter area. Now, in addition to that field being in the Values area, it is also added to the top of the Pivot Table as a Report Filter;

Easily hide zero value rows in a Pivot Table

In the Pivot Table, click the arrow to the right of the Report Filter dropdown, check ‘Select multiple items’, uncheck the 0 value and click OK.

Easily hide zero value rows in a Pivot Table

Now the rows containing zero values in the Pivot Table have been hidden.

Easily hide zero value rows in a Pivot Table

How to Hide Zero-Value Rows In A Pivot Table