Hello.

I have a pivot table that tracks my medical expenses and insurance
benefits.

The layout uses the "Provider" field as a PAGE filter, and so I can see
which provider is being displayed when I choose their name from the
list.

However, there are times that I want to view the information for ALL
providers.   But when I choose the "ALL" selection from the list, I can
no longer tell which information goes with which provider because the
provider's name is not one of the fields listed in the "ROW" layout.

I have tried to add the Provider field to both the Page and Row
sections, but it won't let me have the same field in both sections.
It WILL let me add it to both the Page and the COLUMN sections, but I
can't get it to display the provider's name... it will only "Sum the
Provider" or "Count the Provider," etc.

Does anyone know who I display the field in both the Page and Row
sections;   OR...
How to display the text of this field in the Column section (instead of
summing or counting it).

Thanks!!!

Jessi