Hiding blank cells within a Pivot Table
 

I have a Pivot Table that has G/L Text under Row, Years under Column and the
$$ under Data.

Now, for some of the G/Ls..there is zero or blank data. Is there a way I
can hide these cells within a Pivot..i know that under Table Options there is
a check box for Empty cells but it looks like you have to type something
in...i want to hide empty or zero cells

Is there a way I can do that from a Pivot Table? Any help will be
appreciated.

Hiding blank cells within a Pivot Table
 

http://www.techonthenet.com/excel/pi...hide_empty.php

Regards,
Ryan---

--
RyGuy


"Shams" wrote:

I have a Pivot Table that has G/L Text under Row, Years under Column and the
$$ under Data.

Now, for some of the G/Ls..there is zero or blank data. Is there a way I
can hide these cells within a Pivot..i know that under Table Options there is
a check box for Empty cells but it looks like you have to type something
in...i want to hide empty or zero cells

Is there a way I can do that from a Pivot Table? Any help will be
appreciated.