Cascading Filters Values in Lookups

Cascading Filter Value Lookups allow you to restrict the values appearing in a Lookup based on the select Values of the preceding Filters. In the example an Account Code Lookup is restricted to just the Account Types of the Filter set just before it.
Filters values are passed by name into Filter Sub Queries of the Filters below it. The Sub Queries allow you to custom design what appears in the Lookup as well as Filter down the values based on the Filter values referenced by name in the parent Query.
The video starts with Excel and the reproduces the same Report in Publisher for the Web Channel. The Account Types are set as a Dropdown pick list and a comma delimited list is a set of the valid types.