issue with pivot-tables

[AmyTaylor]

Hi all, I have an issue with pivot-tables:

My pivot-table is sourced from a range with the following column
headers and data:

Name Firstname Middlename Forename

Tom J Jones Tom J Jones
Eric P Jones Eric P Jones
Keith A Daves Keith A Davies
etc

The data comes from an ODBC link to an Accesss query.

If I click Forename on the pivot-table and select Jones, I would only
want to see the available sub selections of Middlename and Firstname
(J, P and Tom, Eric in this example), rather than the full list
including A and Keith at present.

Is there a way of doing this thru pivot-tables?
Thanks
Amy xx

 

[MattShoreson]

You need to have surname as a page field and middle and forename as row
fields.

The row fields will filter on your page field selection.

 

[Tom Ogilvy]

What version of Excel supports this?

--
Regards,
Tom Ogilvy

"MattShoreson" <[email protected]>
wrote in message
news:[email protected]...

 

[MattShoreson]

Do you not see the row fields being updated when you select a different
page field?

I am current on office XP.

I think you are hoping for a perfect solution whereby the row field
LOVs are updated to not display non-entries.

However in the data section of the pivot all info pertaining to the
selected surname in the page field will be filtered.

Tom, I'm sure a man of your expertise/experience will see the principle
I was trying to convey.

 

[Tom Ogilvy]

On first read, I thought you were answering the question which I understood
to be asked (which is not supported in pivot tables to the best of my
knowledge). In actuality, I now understand you to say you were offering an
alternative concept.

I think you are hoping for a perfect solution whereby the row field
LOVs are updated to not display non-entries.

I wasn't, but the OP appeared to be. (if LOV's means the item dropdowns)

--
Regards,
Tom Ogilvy




"MattShoreson" <[email protected]>
wrote in message