Can Pivot display text as data values

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: john.doe@mail.com

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

Br, Tommy

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

In article <0a6701c3b037$29229d10$a301280a@phx.gbl>,
anonymous@discussions.microsoft.com says...
> 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: john.doe@mail.com
>
> I know Pivot wasn't meant for this purpose, but it would
> be a good tool for that, too.
>
> Br, Tommy
>