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 answers

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