issue with pivot-tables

  • Thread starter Thread starter AmyTaylor
  • Start date Start date
A

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
 
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.
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top