Posted to microsoft.public.excel.programming

external usenet poster

Posts: 11

Hiding 0 values in Pivot Table

I have a pivot table, how do I hide values of 0? I don't
want this data to show up in the pivot. Most of the data
is 0.

Thanks,

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Pivot Table Hiding Totals = Zero	Mnilo	Excel Worksheet Functions	0	December 13th 08 05:05 PM
Hiding Zero Values in a Pivot Table - MS Excel 2007	Taveras	Excel Discussion (Misc queries)	4	October 9th 08 08:21 PM
Pivot Table - Hiding Zero Values	lcrean	Excel Discussion (Misc queries)	2	September 3rd 08 12:21 PM
hiding zero values in a pivot	ziak	Excel Discussion (Misc queries)	1	May 15th 07 10:29 PM
PIVOT TABLE - hiding records with CALCULATED item values equal to	Pele	Excel Discussion (Misc queries)	0	March 10th 06 04:15 PM

All times are GMT +1. The time now is 10:20 PM.

About Us

"It's about Microsoft Excel"