#1
|
|||
|
|||
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)) |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
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 |