Hiding blank cells within a Pivot Table

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.
 

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

Top