zeros generated by a calculated item in pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Thank you for your answer. However, what I need is to hide the full line
(because all cells are empty and the one re: to the calculated field is
zero), not just put a blank instead of a zero.

Any idea?
 
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.
 
Back
Top