Drill in formula reports

You can drill into a cell that contains an XL3Member formula to show details about its components.

To use the drill-down feature, double-click a cell that contains an XL3Member, and depending on the current state of the workbook, it'll:

The children of the hierarchy member double-clicked on are displayed. This is done by looking at which cells refer to the current cell. This option drills down to the level beneath the one selected in the current cell. It'll attempt to determine the best place to insert the new columns or rows. Using this option with a heavily disjoint report may not produce the expected results.

The children of the hierarchy member double-clicked on are removed from the report.