Difference between revisions of "Skip Levels"
(Created page with "From Version 9 you can use this feature to remove levels from your report, which can be useful when drilling. This can be used in Grid, small multiples|Small...") |
|||
| Line 1: | Line 1: | ||
From [[Version 9]] you can use this feature to remove levels from your report, which can be useful when drilling. | From [[Version 9]] you can use this feature to remove levels from your report, which can be useful when drilling. | ||
| − | This can be used in [[grids | + | This can be used in [[Grid|grids]], [[Small Multiple Charts|small multiples]] and tree [[Dimension Slicers|slicers]]. |
=Grids= | =Grids= | ||
Revision as of 10:03, 6 October 2016
From Version 9 you can use this feature to remove levels from your report, which can be useful when drilling.
This can be used in grids, small multiples and tree slicers.
Grids
In this example, we have a hierarchy that contains:
- Year
- Semester
- Quarter
- Month
- Day
And we want to skip past the semesters, and go directly to the quarters.
In the member selector for Date we go to the Advanced section, and in the Skip Levels screen untick the Calendar Semester level.
The result is that when we drill years we next see quarters
Slicers
We will make the same changes in a slicer, remembering to select "Use query restrictions for children".
the result is a tree that again goes directly from year to quarter.
