zeros generated by a calculated item in pivot table
 

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?

zeros generated by a calculated item in pivot table
 

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?

zeros generated by a calculated item in pivot table
 

Thank you for your answer. However, what I need is to hide the full line
(because all cells are empty and the one to the calculated field is
zero), not just put a blank instead of a zero.

Any idea?

"Ian" wrote:

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?

zeros generated by a calculated item in pivot table
 

I thought you said hiding the line was not an option because it hides the
title.

I can't think of a quick answer and I have to go out now. Hopefully someone
else can help.

--
Ian
--
"Frederic" wrote in message
...
Thank you for your answer. However, what I need is to hide the full line
(because all cells are empty and the one to the calculated field is
zero), not just put a blank instead of a zero.

Any idea?

"Ian" wrote:

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?