Hide zero value lines within a pivot table in Excel 2003/XP/2000/97


Great article with screenshots.. Doesnt get any clearer than this:

Spreadsheet123.com

Too bad it doesnt work for rows adding up to 0 in the pivot (say source has a -10 and 10, so the pivot shows 0, the trick above doesn’t work for that)..