| Anchor | ||||
|---|---|---|---|---|
|
Drill into can be used for a member of any dimension, that has several levels. Click on a member and select Drill into. It will show the next level of a member.
This is useful, if you want to see all the levels of a measure, and if you are using Total function, so that values are not included twice.
Drill into level
If you want have a range of members that are sorted - please to drill into another level of the member, you can use Drill into level functionality like it is shown below
.
For example - if selected member level is year in time dimension, you can drill into quarter, month or day level.
Try it yourself below:
| Iframe | ||||||
|---|---|---|---|---|---|---|
|
| Info |
|---|
Please note - if you would like to have all members in level you are drilling into - make sure that Hide Empty button is switched off. If it is not - you will see only those rows or columns that have values . |
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
Drill through