Go to ToolsOptionsView and uncheck Zero values.

--
Ian
--
"Frederic" wrote in message
...
I added a calculated item in my pivot table. It generated lots of lines
with
zeros that did not exist before (indeed the result of my calculation is
zero
since there is no data); and even, if you double-click on the generated
zero,
you can see that there is no data behind.

Filtering results is not satisfactory to me, because:
1. it does not solve the calculation time issue
2. it hides the row tittel on the left when there is a zero on the same
line

Can anyone truly solve this issue?