On the toolbar PivotTable menu (doesn't work if you right-click), choose
Formula and then Calculated Field or Calculated Item; both of these
options allow for dynamic entries. I forget which one you'll need to
use in this case...but it'll give you a start until someone else can
respond.

-JC


--
carlyman
------------------------------------------------------------------------
carlyman's Profile: http://www.excelforum.com/member.php...o&userid=22440
View this thread: http://www.excelforum.com/showthread...hreadid=540422