Avoid displaying zero in Excel pivot table
Cécile
-
RYE -
RYE -
Hello,
I am working with a data sheet containing data imported from an Access database and calculated fields. This field contains some numeric values (greater than 1) and a majority of empty cells.
When I use PivotTable, the empty cells are "transformed" into cells containing a zero. However, I would like to have empty cells instead.
I checked the PivotTable options, and the "empty cells" option is checked and it contains no value.
=> I have a second field of the same kind (with numeric values and empty cells) that does not give me any problems. The difference is that it is not a calculated field. It comes from the Access database.
Thank you for your help
Cécile
I am working with a data sheet containing data imported from an Access database and calculated fields. This field contains some numeric values (greater than 1) and a majority of empty cells.
When I use PivotTable, the empty cells are "transformed" into cells containing a zero. However, I would like to have empty cells instead.
I checked the PivotTable options, and the "empty cells" option is checked and it contains no value.
=> I have a second field of the same kind (with numeric values and empty cells) that does not give me any problems. The difference is that it is not a calculated field. It comes from the Access database.
Thank you for your help
Cécile
3 answers
-
Hi,
If you right-click on the pivot table, and click on options, you can check the box "show empty cells" and clear the box next to it.
Hope this solves your issue.
Brooklyn. -
If it's a calculated field, you can try adding a condition =if(calculated_field=0;""";calculated_field).
@+
Brooklyn -
Hello,
I am facing the same problem as Cécile.
I have a database on one tab, and it only displays the rows in the Pivot Table where there is a value.
With a calculated field, I measure a delta.
As a result, it shows me all the rows, most of which only display zeros...
Help!