+ Reply to Thread
Results 1 to 2 of 2

Pivot Table Dropdown Updating on Fly?

  1. #1
    Registered User
    Join Date
    10-24-2008
    Location
    New York
    Posts
    10

    Pivot Table Dropdown Updating on Fly?

    Hi All,
    I'm in the process of creating a pivot table but I've run into a problem. My pivot table has a drop down menu so I can choose which areas to filter and my pivot table updates accordingly. The problem is, I need the drop down to update on the fly when choosing an option from one of the other filters.

    Context: I have two rows of data, one with city and one with country. When I choose the country in one of the drop down filters, I want the city drop down to update accordingly so it only shows those cities in that country and not all of the other cities in other countries. Is there any way I can do this? I'm sure there is, but I have no idea how. Any help would be greatly appreciated. Thanks in advance.

  2. #2
    Registered User
    Join Date
    10-24-2008
    Location
    New York
    Posts
    10

    Re: Pivot Table Dropdown Updating on Fly?

    Any help at all would be greatly appreciated. Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1