Q29. In a table you display a time hierarchy with the years 2024, 2025, and 2026. Months, quarters, and half years are also displayed for each year. You want to apply the formatting of the year 2024 to the years 2025 and 2026. In styling rules, which level option do you select?
To apply the formatting of the year 2024 to the years 2025 and 2026, you need to use the level option Self and Descendants in the styling rules. This option applies the formatting to the selected member and all its lower-level members in the hierarchy1. In this case, the selected member is the year 2024, and its lower-level members are the months, quarters, and half years that belong to 2024. The formatting will also be applied to the years 2025 and 2026, and their lower-level members, because they are at the same level as 2024 in the hierarchy.
The other level options are:
Self: This option applies the formatting only to the selected member, not to any other members in the hierarchy1. In this case, the selected member is the year 2024, and the formatting will not be applied to any other years or lower-level members.
Self and Siblings: This option applies the formatting to the selected member and all its siblings, which are members at the same level in the hierarchy1. In this case, the selected member is the year 2024, and its siblings are the years 2025 and 2026. The formatting will be applied to these three years, but not to their lower-level members.
Self and Children: This option applies the formatting to the selected member and its immediate children, which are members one level below in the hierarchy1. In this case, the selected member is the year 2024, and its immediate children are the quarters and half years that belong to 2024. The formatting will be applied to these members, but not to any other years or months.
Reference:
1: Styling Rules for Tables
