zeros generated by a calculated item in pivot table

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?
 
G

Guest

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

Ian

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2007 Pivot table Calculated field misbehaving 1
N/A in pivot table become 0 1
Calculated Item in Pivot table 1
Hiding blank cells within a Pivot Table 1
zero value in cell 2
Pivot table NOT showing zero value calculations 2
How to "blank" pivot table calculated fields if result = 0 3
Zeros in calculated items in pivot tables 5

Top