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


--
AmyTaylor
------------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970
View this thread: http://www.excelforum.com/showthread...hreadid=470685

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.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=470685

What version of Excel supports this?

--
Regards,
Tom Ogilvy

"MattShoreson"
wrote in message
news:MattShoreson.1vynqb_1127729118.4883@excelforu m-nospam.com...

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.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile:
http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=470685

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.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=470685

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"
wrote in message
news:MattShoreson.1vz76h_1127754332.4165@excelforu m-nospam.com...

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.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile:
http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=470685