Displaying 0% as blank in pivot table?

		Microsoft Office Forums > Microsoft Excel > Excel
Displaying 0% as blank in pivot table?

FAQ

Thread Tools

Display Modes

New Daddy Displaying 0% as blank in... 11-25-2013, 06:37 PM

SteveBump I'm not an expert, but could... 12-04-2013, 08:54 AM

BobBridges I didn't read this at first... 12-05-2013, 07:54 AM

New Daddy That worked like magic!... 12-06-2013, 07:34 AM

BobBridges Ain't that the truth? There... 12-06-2013, 08:28 AM

11-25-2013, 06:37 PM

New Daddy

Windows Vista Displaying 0% as blank in pivot table?

Office 2003

Advanced Beginner

Join Date: Jan 2012

Posts: 90

Displaying 0% as blank in pivot table?

I'm displaying a column as % of row total, and some are showing up as 0%. Can I just make Excel show them as blank? I do NOT want to hide them with filter. I want these data to take space in the pivot table, but with blank rather than with "0%". I couldn't find any solution on Google.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word is displaying my "compatible" docs as blank!	RobDuBois	Word	3	01-20-2013 04:40 PM
Pivot Table	uhlersa	Excel	0	10-15-2012 12:01 PM
pivot table	aliasadi_07	Excel	1	03-11-2012 12:49 AM
Table of Contents is not displaying	mhb0825	Word	1	01-04-2012 03:21 PM
Pivot Table	Karen615	Excel	5	08-03-2011 10:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:29 AM.