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, 10:43 AM

patidallas22 patidallas22 is offline

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

Office 2007

Novice

Join Date: Mar 2012

Posts: 12

Excel Pivot - Do not display rows with zero value

Is there a way in a pivot table to have the pivot not show rows that have a zero value from my data page?

Because the cell has a formula that adds up to $0, it still shows up in the pivot. I want the pivot to ignore any rows that show the formula as zero.

I even used the following formula in my cell so it shows no value, but the pivot still picks up this cell as $0.

=IF(SUM(J2:Z2)=0,"",SUM(J2:Z2))

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 05:38 AM.