Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-08-2013, 10:43 AM
patidallas22 patidallas22 is offline Excel Pivot - Do not display rows with zero value Windows XP Excel Pivot - Do not display rows with zero value Office 2007
Novice
Excel Pivot - Do not display rows with zero value
 
Join Date: Mar 2012
Posts: 12
patidallas22 is on a distinguished road
Default 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))
Reply With Quote
  #2  
Old 03-08-2013, 01:35 PM
patidallas22 patidallas22 is offline Excel Pivot - Do not display rows with zero value Windows XP Excel Pivot - Do not display rows with zero value Office 2007
Novice
Excel Pivot - Do not display rows with zero value
 
Join Date: Mar 2012
Posts: 12
patidallas22 is on a distinguished road
Default

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!
Reply With Quote
Reply

Tags
pivot tables, zero value

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Pivot - Do not display rows with zero value 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
Excel Pivot - Do not display rows with zero value Is this sort of pivot possible in the Excel? Jamal NUMAN Excel 4 02-14-2012 02:48 PM
Excel Pivot - Do not display rows with zero value 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 09:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft