View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Supress (blank) in pivottable

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