Posted to microsoft.public.excel.misc

external usenet poster

Posts: 230

Pivot Table show Zero problem

There is an option with Pivot tables (In Layout and Format) to show "0" in
the "For empty cells to show:" field
However - I find that if all the fields are empty, then "0" is not shown. ie
a "0" will only appear in any of the blank field only if ,at least, one of
the other fields has a value.

Is there a way to always have a "0" show even if all the fields are blank
(empty)?

Rob

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show pages without using pivot table	PA_Mom	Excel Discussion (Misc queries)	1	March 9th 07 04:10 PM
Pivot Table Show Top 10 Error	Native	Excel Discussion (Misc queries)	1	September 17th 06 07:36 PM
Show all data in pivot table	naulerich	Excel Discussion (Misc queries)	2	March 1st 06 09:42 PM
show detail in pivot table	robbie	Excel Discussion (Misc queries)	5	June 14th 05 09:15 PM
show only > 9 in a pivot table	jenn	Excel Worksheet Functions	1	December 7th 04 09:11 PM

All times are GMT +1. The time now is 01:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us