How to "blank" pivot table calculated fields if result = 0
 

I have a pivot table that works wonderful.
However I have three calculated fields in the data area of the pivot table.
If those calculated fields have nothing to calculate they return 0.
Is there a way to "blank" all those unnessary zeroes when obviously there
is no dependent data to calculate.
I've got the setting correct to show " " when the dependent data is blank.
I'm just stuck on the calculated fields.
Thank you in advance for your help.

How to "blank" pivot table calculated fields if result = 0
 

would tools options view and untick zero values work?


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=520223

How to "blank" pivot table calculated fields if result = 0
 

Steve .... you are the "man".
This worked perfectly !
Thank you very much,
Joe

"steven1001" wrote:


would tools options view and untick zero values work?


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=520223

How to "blank" pivot table calculated fields if result = 0
 

s
"Joe" escreveu na mensagem ...
Steve .... you are the "man".
This worked perfectly !
Thank you very much,
Joe

"steven1001" wrote:


would tools options view and untick zero values work?


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=520223