Drillthrough in Anaplan XL Reporting

Drillthrough is used to list the base data from the database that constitutes the cell on the spreadsheet.

The Drillthrough option is available on the right-click pop-up menu when:

• the currently active cell contains an XL3Lookup formula.
• the currently active cell is part of the data area of an active grid.

Select a cell and choose Anaplan XL > Drillthrough... from the right-click button menu to display the Drillthrough dialog.

• The Destination field determines where the Drillthrough information will be placed on the worksheet.
• The Limit rows field allows you to limit the returned result set.
• You can create a new worksheet to place the data on by selecting New Sheet and entering a name for the worksheet.

The drillthrough places the returned data directly onto the spreadsheet. The values inserted are values and not formulas.