- Organize data into hierarchy by drag dimension to other dimension. In the example, the Topic is a hierarchy structure, with L1Topic>L2Topic>Item.
- Hierarchy structure can be used for Conditional filter. In the following examples, when the L1Topic is selected for Mobility or Labour main topic respectively, the L2Topic automatically shows only the associated sub-topics.
- Sort field by value of another field. Before sorting the L2Topic and Item fields, the rows are in alphabetical order as default.
Select sort for the field and choose sort by field, select Item ID as field name and choose sum as aggregation method.
The L2Topic and Item are now ordered by Item ID which doesn’t have to show in the result table.
4. Hierarchical Filter Configuration
- In the filter, select only relevant values for the hierarchical filter to take effect.
- When data source are linked, the “Only Relevant Values”, “All Values in Hierarchy”, and “All Values in Database” may disappear, then you will not be able to use the hierarchical filter.
