Execute Drilldown
Drilldown allows you to extract additional detail about a specific “Get Balance” function.
- Select a cell that contains a valid Get Balance function.
- Click on the “Drill to Next Level” button, or double-click on the Get Balance function.
- A drilldown sheet is created either in the current workbook or in a new one depending on your selected GL Wand User Options.
- If applicable, the criteria sheet will be populated with the criteria from the Get Balance function (See the Create Drill Criteria Sheet section for more details and options on the drilldown criteria sheet).
- The drill down to balance detail will be executed showing all the detailed intersections that make up the total in the Get Balance function.
There are a variety of options which can be performed from the drilldown workbook.
- Modify the parameters on the criteria sheet and perform a new “Execute Drilldown”. Drop down lists are provided for most of the parameters.
- Select the “Balance Detail” sheet, select one or more rows with “Execute Drilldown” in the “Drill to line item” column, and then click the “Drill to Next Level” button to drill to line item details.
- Select the “Line Items” sheet, select one or more rows with “Execute Drilldown” in the “Drill to Document” column, and then click the “Drill to Next Level” button to drill down to the document detail.
When drilling down you have the following options:
- Double click any cell on the row that you wish to drill down on. This will execute the default drilldown for that row.
- Select any cell in the row that you want to drill down on and click the “Drill to Next Level” button on the toolbar. This will execute the default drilldown for that row.
- Highlight a range of rows and click the “Drill to Next Level” button on the toolbar to drill down on multiple lines at once.
- Highlight non-contiguous rows using the “Ctrl” button and click the “Drill to Next Level” button on the toolbar to drill down on multiple lines which are not adjacent to each other.
Other important things to note about drill downs:
- It is possible to drilldown through multiple drill levels at once e.g. from a Get Balance formula directly to the Document level. See Drill to Document for more detail.
- The drilldown results can be sorted and subtotaled using the Template Layout option.
- You can add calculated columns in Excel in between the drilldown results and these will be refreshed with subsequent drilldowns. See Template Layout for more details.
- You can save a drilldown layout including all Excel formatting and other Excel components like charts and pivot tables for reuse. See Save Template Layout for creating a saved layout and Drill Using a Saved Template for using a previously saved layout.