XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Drilling in Formula Reports

Revision as of 09:43, 12 October 2010 by Antonio.remedios (talk) (Corrected link)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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

See Also