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
wacNTN wrote:
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
--
WAC
--
Dave Peterson