Wed 22 Feb 2012, 10:36Delegate David said...
David has attended:
Excel Advanced course
Pivot Tables
I have created a pivot table from a sorted sheet. The sorted sheet hides rows returning a nil value. These appear in the pivot table but I do not want to include them. How do I keep them out?
Tue 28 Feb 2012, 11:14Trainer Paul said...
RE: Pivot Tables
Drag a copy of the value to the filter, right click on the filter drop down arrow, select multiple and deselect 0. This link will help you out.
http://www.techonthenet.com/excel/pivottbls/hide_blanks2011.php
Cheers
Paul
