S
Shams
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.
$$ 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.