HierarchyFilter
A HierarchyFilter filters data by drilling down through an ordered list of columns. Each level in the list narrows the data by one column, and the selected values at each level determine which values are available at the next.
Types
Properties
The column that anchors the filter. This column determines the dataset that the whole filter applies to, so every column in HierarchyLevels and in HierarchyTree must belong to the same dataset.
The default configurations for the associated controls. This applies only for filters that are scoped to multiple sheets.
The ordered list of columns that defines the drill-down path of the filter. The first level is the top of the hierarchy. You can specify a maximum of 5 levels.
The tree of selected values for the filter. Each node records the values that are selected at one level of the hierarchy, and its children record the selections beneath those values. Omit this attribute to define the drill-down path without restricting any values.
Determines whether the values selected in HierarchyTree are kept or removed. Choose one of the following options:
This option determines how null values should be treated when filtering data.