Microsoft Office Forums - View Single Post - Excel Pivot - Do not display rows with zero value

Thread: Excel Pivot - Do not display rows with zero value

View Single Post

Old

03-08-2013, 01:35 PM

patidallas22 patidallas22 is offline

patidallas22 is offline

patidallas22 uses Windows XP

Windows XP patidallas22 uses Office 2007

patidallas22 uses Office 2007

Office 2007

Novice

The original poster

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