Many thanks !! You did it !!! Could you please advise how you did it step by
step ?

I found no calculated items or calculated field. How to produce this
additional column ??

Thanks.

"Gary Brown" wrote:


You should still be able to do this even though you only have one value
column.

I have attached an example to show you what I mean


+-------------------------------------------------------------------+
|Filename: example pivot.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4659 |
+-------------------------------------------------------------------+

--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=534087