you could try using a calculated field inside the pivot table
< pivot table toolbar < Formulas < Calculated Field.


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