Loading...

How To Create and Use Hierarchical Filter

Link to the video

Under this link you will find a video that shows how to create and Use Hierarchical Filter. Here you will find Documentation.


Step by step

  1. Right-click chosen folder in Solution Explorer to add a new item, choose Filters:

pic

  1. Drag and drop dimension to create a Filter Container:

pic

  1. Configure it:

pic

  1. Using the hierarchy name:

pic

  1. Drag and drop the Filter in the Worksheet:

pic

  1. Drag and drop the Filter in the Workbook:

pic

  1. Set up the Selection Changed event in the Filter:

pic

  1. Than the Loading event for the Workbook or Page:

pic

  1. Bind the filter for your Table in Workbook:

pic

  1. For the Hierarchical Filter TreeView is the best view:

pic