Excel Pivot - Do not display rows with zero value

		Microsoft Office Forums > Microsoft Excel > Excel
Excel Pivot - Do not display rows with zero value

FAQ

Thread Tools

Display Modes

03-08-2013, 01:35 PM

patidallas22 patidallas22 is offline

Windows XP Excel Pivot - Do not display rows with zero value

Office 2007

Novice

Join Date: Mar 2012

Posts: 12

Nevermind, I figured out my own answer!

For those who need to know, you drag the column that has the sum into "Report Filter", then deselect "0" and then put it back. Then the rows that have a zero value disappear!

Tags

pivot tables, zero value

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Grouping Dates in Excel Pivot Table	mskennedy	Excel	2	02-27-2013 11:09 AM
Excel Pivot Table Calculated Field	BertLady	Excel	0	05-21-2012 10:51 AM
Is this sort of pivot possible in the Excel?	Jamal NUMAN	Excel	4	02-14-2012 02:48 PM
Excel 2010 Pivot Table Qs	SchneeBaer	Excel	2	10-03-2011 08:45 PM
linking Excel pivot into PowerPoint formatted	nhegler	PowerPoint	0	11-22-2010 08:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:50 PM.