Put the 'Description' as both the row field and the data field.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

I want to create a pivot table. I have a field named 'Description'.
There are various machines within. I would like to have a chart that
tells me how many P2 266s that I have, how many, P3 500s.......etc.
Unfortunately, I cannot find my answer when I go to the HELP menu of MS
Excel. Any help would be appreciated. Thanks a lot.

Larry


--
lkw441
------------------------------------------------------------------------
lkw441's Profile: http://www.excelforum.com/member.php...fo&userid=2622
View this thread: http://www.excelforum.com/showthread...hreadid=376842