try adding an extra column to the data which contains a label of 'hide'
or display' where that value is determined by using a sumif calculation
so that if the sum of all trx values for a project is zero then it gets
a label of 'hide' else 'display'. Then in the pivot table put the
'hide/display' label in the Page area and select only 'Display'.

Formula would look like assuming the column headings were in row A ...
'=IF(SUMIF($A$2:$A$100 [the list of projects],$A$2:$A$100 [the list of
projects],$B$2:$B$100 [values for each project])=0,"Hide","Display")

... it worked when I tested it :-)


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