How to Hide Zero Values in Pivot Table in Excel

How to hide 0 values in PivotTable?

To hide zero values in an Excel PivotTable:

• Right–click in the PivotTable
• Select “Value Filters“
• Choose “Does Not Equal” and then enter “0“.

This will filter out all zero values.

How do I remove zeros from a PivotTable average?

To remove zeros from a PivotTable average in Excel, use a calculated field.

• Right-click the PivotTable, select “Calculated Field”
• Create a formula like ” =IF(Value=0, NULL, Value) ” to exclude zeros from the average calculation.

One of Microsoft Excel’s most important features is the pivot table. You might be aware of this if you have worked with it. It provides us with a thorough view and insight into the dataset. You can do a lot with it. The pivot table might include zero values.

In this lesson, you will learn how to hide zero values in the pivot table using relevant examples and visuals. Hide the rows in a pivot table that have zero values. After concealing the zero-value rows, your pivot table will seem neater and the data will be suppressed.

Implementation

Let’s take a dataset as an example to understand How to Hide Zero Values in a Pivot Table in Excel. This is the dataset that we are going to use in this scenario.

The Excel table has some zero values, as you can see. First, you must transform an excel table into a pivot table. You may need to hide them at times to have a clear view of the pivot table.