MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel - Pivot table


Posted by Bent Høier on October 18, 2001 11:39 PM

Hi MrExcel

How do I, in a Pivot table in the Data area, show a text instead of a number or count?

I use a query from an MS Access database to create the Pivot table.


Posted by Don C on October 19, 2001 4:53 AM

The purpose of pivot tables is to do counts, or variations on counts (e.g. percents). If what you want to do is not a count, then you needa different function/tool than a pivot table.

Tell us more about what you are trying to accomplish and we might be able to help you.

Posted by lenze on October 19, 2001 5:30 AM

Although you will have to use a count or some other math variable in the data field, you can also display the contents of that field by also adding it as a Row item in your Pivot Table. For instance, suppose you had four types of items, such as widgets, wingding, etc. and each type had several models with a unique part number. Make you 1st row item Type, the 2nd Part Number, and the Data Field "Count of Part Number". Your Pivot table will then display the Part Numbers for each type of item. You may hide the column with count if you wish.

HTH