Hello all,
I am having some trouble with items in the drop down list of filters of a pivot table.
For example, I have 3 filters for my pivot table.
Filter 1: Region (e.g. North, South, East, West)
Filter 2: Neighborhood (i.e. Names of neighborhoods)
Filter 3: Street Names
After selecting a particular Region (e.g. South) and Neighborhood (e.g. Queenstown), the drop-down list in Filter 3 shows all Street Names in the entire database.
However, it is quite an overwhelmingly long list to scroll through to select the Street Name(s) that I am interested in.
Is there a way to show only the Street Names of the selected Region and Neighborhood in the drop-down list in Filter 3? Following which, I can select multiple Street Names of interest from a shorter and filtered list.
I know that it is possible with slicers but first, they are slightly bulky on the page and takes up quite a lot of space and second, I can only select 1 Street Name at a time.
Thanks!
Bookmarks