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:
[Quoted Text] >
> 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
|