View original (French)

Avoid displaying zero in Excel pivot table

Cécile -  
 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

3 réponses

Réponse 1 / 3
BROOKLYN
 
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.
0
Réponse 2 / 3
Brooklyn
 
If it's a calculated field, you can try adding a condition =if(calculated_field=0;""";calculated_field).
@+
Brooklyn
0
Réponse 3 / 3
RYE
 
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!
0