Can Pivot display text as data values

[Tommy]

Hi!

I'm trying to create a "dynamic phonebook" using Pivot.
I.e. I can select from Page e.g. City and department, in
Row Field there's listed Role and Name and In Data Items
phone number and email-address.

It basicly looks great, but it seems its impossible to
display text values of the data. Is it possible to display
text in data items?

Example

Page:

City:Capitol City
Dep.:IT-Department

Rows:

Role: Field Engineer
Name: John Doe

Data:

Phone: 01 23456
Email: (e-mail address removed)

I know Pivot wasn't meant for this purpose, but it would
be a good tool for that, too.

Br, Tommy

 

[Tushar Mehta]

The answer to your specific question is no. However, you can fake the
effect. Put the text fields as row fields (subordinate to the real row
fields). Finally, have no data fields! Double-click each of the row
field headers and set the Subtotal to None.


--
Regards,

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