Pivot Table - Problem Viewing a Field

[Jessi]

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

 

[Guest]

Two possible solutions but not very good.

1. Add an extra column to your data and copy the provider then you can have
the porvider in the page and the column; or
2. Put the provider in the table proper and use the selection options on the
field for the column.

 

[Roger Govier]

Hi Jessi

Which version of Excel are you using?
I cannot get the same field used in both Column AND Page area in XL2003
or XL2007.

What are the field headings you are using, and what is it you want to
display?
Maybe if you add Provider to the Row area as the first filed, before
whatever you have as your current Row item(s), and double click on the
field and set Subtotal to None, you will be able to achieve what you
want. Using the dropdown on Provider will allow you to select just one,
or All

 

[Jessi]

Many Thanks!

Your first option worked. I was able to achieve the effect I needed
by adding another column, and putting a formula in it to copy the data
from the provider column. I then used the second column in my Row
area.

 

[Jessi]

Hi, Roger:

I am using Excel 2002. I goofed in my earlier description... I
should have said "Data" section, not "Column" section. Sorry!

Jessi