You could use this formula in column D:
=IF(ISBLANK(A5),A4,A5)

You can't do what you want to do, in the Pivottable.

Ola


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378947