Let's say I have two comboboxes in the page area of an Excel 2000 pivottable.
The top combobox named states is the list of 50 states and the lower combobox
named 'cities' is a list of major cities for each state.

What I'd like to see happen is to only show the cities associated with their state when a specific state is selected. I know that the comboboxes work as filters, but a user has asked if this type of functionality can be made to work inside of a pivottable.