another possible approach..
Assuming the data is in the spreadsheet, in the column next to the
value column just use a formula like =if(<cell=0,"hide","display").
Include the column in the pivot data range and then just put this
column label in the PAGE area and select only "display".

regards..


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=518884