Try something like this:

Build the Pivot Table the way you want to....
in the DATA area: Drag one of your text fields (it will default to "Count of "

Then finish the Pivot Table.
Hide the Total column

Is that something you can work with?
***********
Regards,
Ron

XL2003, WinXP


"HERZHIS" wrote:

I need a Pivot table that shows skill levels for equipment
scenario:
to repair a boiler, From a Pivot Table the saleman would bring up Boiler and
see who would be the right man to repair

I have
12 pieces of equipment
15 techs
5 skill levels

No numeric data, I do need to compare numbers
--
Thanks again, Herz and His