Supress (blank) in pivottable

[Guest]

I have a pivottable like this.

Area Group Description
Budget
1. Strategic iniatives Business Growth Buy product X $1
Buy product Y
$5

1. Technology upgrades Convert sys A Programming $1
(blank)
$5

Excel is putting in the (blank) text because I don't have anything in the
cell in the source table and I don't have anything I want to put in that cell
- not even "Other"! Can I supress (blank) somehow? Other than putting a
space in those cells?

Thanks,

Walter

 

[Dave Peterson]

I could just type over that cell with (blank) in it.

If you have trouble, maybe using Debra Dalgleish's pivottable addin would
help--besides, there's lots of other stuff in that addin that you may like:

http://www.contextures.com/xlPivotAddIn02.html