As a page builder, you can enable a hierarchy filter on a board or a worksheet.
A hierarchy filter synchronizes the data items across grids by hierarchy. You can enable this using the Rows and Columns switches within the Card designer.
When you enable these switches for a secondary grid, end users can select a parent item on a main grid, and the secondary grid will display the child items.
This is useful if, for example, your main grid displays sales areas, and your secondary grid displays sales personnel.
When you create a hierarchy filter, the module used as a data source must contain parent and child items from a common hierarchy. You cannot configure a hierarchy filter if the primary grid is based on the lowest level of a composite list.
Hierarchy filtered grids are fully customizable. For example, you can show/hide, pivot, or sort your data.
Learn how to configure a hierarchy filter.