View original (French)

Do not display 0 in a pivot table

Solved
Grande Brune Posted messages 20 Status Member -  
Grande Brune Posted messages 20 Status Member -
Hello,

How to avoid displaying "0.00%" in a pivot table in Excel 2003, resulting from a count summary with "% of total"?
I have seen that in the general options of pivot tables, you can request to hide zeros, but it doesn't work for this column.

Thank you in advance for your help.
Best regards,
Joëlle
Configuration: Windows XP Internet Explorer 7.0

1 answer

  1.
    Grande Brune Posted messages 20 Status Member 8
     
    I solved my problem. Just select the relevant cells and create a custom format based on the existing one: "0.00%" and modify it like this <0.00%;;""> (format for positive values, format for negative values, and format for zero).

    There you go.
    9