Drilling in Formula Reports
A cell that contains an XL3Member formula can be drilled into to show details about its components.
To use the drill down feature, double-click on a cell that contains an XL3Member and depending on the current state of the workbook, it will:
- Drill down
- the children of the hierarchy member double-clicked on will be displayed. This is done by looking at which cells refer to the current cell. This option will drill down to the level beneath the one selected in the current cell and will attempt to determine the best place to insert the new columns or rows. Using this option with a heavily disjoint report may not produce expected results!
- Drill up
- the children of the hierarchy member double-clicked on will be removed from the report