When navigating through a hierarchy selection, it is often that a user wants to see a list of available parents or children instead of only being able to see one at a time when looking at drop-down filters. Here is an alternative using the more complex listbox breadcrumb type approach for three levels:
Set up the data as shown next. The blue section contains the initial full hierarchical data. The yellow section contains each breadcrumb trail whose source is one column less than the parent. More about how everything works will be explained in the How it Works section.
Insert three List Box selectors onto the canvas. On the first List Box selector, set the Labels to the Region, Column A, in blue.
Select Filtered Rows as the Insertion Type and set the Source Data to columns A to C. Set the Destination to columns E to G. Notice that we select all three source columns because the first row of the first column of the destination...