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.

would >tools >options >view and untick zero values work?

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

s
"Joe" <Joe@discussions.microsoft.com> escreveu na mensagem =
news:1EA28685-8C04-4E77-BC09-98C291E7B47F@microsoft.com...
Steve .... you are the "man".
This worked perfectly !
Thank you very much,
Joe

"steven1001" wrote:

>=20
> would >tools >options >view and untick zero values work?
>=20
>=20
> --=20
> steven1001
> =
------------------------------------------------------------------------
> steven1001's Profile: =
http://www.excelforum.com/member.php...userid=3D30757
> View this thread: =
http://www.excelforum.com/showthread...eadid=3D520223
>=20
>