How to create cascading effect in filter for Data View Plus web parts

Title
How to create cascading effect in filter for Data View Plus web parts
URL Name
How-to-create-cascading-effect-in-filter-for-Data-View-Plus-web-parts

Question
Answer

Option 1:

  1. Add 2 filter controls, one under the other.
  2. Filter the first one, and the options in the second one will be filtered
  3. Title before filtering based on assigned to:

4. Filtering by assigned to, then by title have less options: 

Option #2

Same idea, but first level filter is done by using conditional formatting as a filter/categories.

Security, Compliance & Governance