s
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
- Right-click the selected folder in the Solution Explorer to add a new item, choose Filters:
.png)
- Drag and drop dimension to create a Filter Container:
.png)
- Configure it:
.png)
- Using the hierarchy name:
.png)
- Drag and drop the Filter in the Worksheet:
.png)
- Drag and drop the Filter in the Workbook:
.png)
- Set up the Selection Changed event in the Filter:
.png)
- Than the Loading event for the Workbook or Page:
.png)
- Bind the filter for your Table in Workbook:
.png)
- For the Hierarchical Filter TreeView is the best view:
.png)