Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Table's DataSource (XP)

    I am having a challenge with a dynamic range as a datasource for a pivot table. The challenge is only to view items listed in a field that has a filter applied to it.

    I have attached an example workbook to demonstrate what I am trying to achieve.

    Thanks for your assistance.
    John
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot Table's DataSource (XP)

    You don't filter the data source, but add Type as page field to the pivot table. You can then select a type from the dropdown list in the page field. See attached version.
    Attached Files Attached Files

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Table's DataSource (XP)

    Hans,

    Your suggestion worked.

    Regards,
    John

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •