Drill down to the data

You can use Drill Down on any cell that contains a formula or summary. 

Drill Down:

• Enables you to drill down through many levels and modules. It shows the formulas used to calculate values and the data cells referenced in the calculations.
• Allows you to expand and view the drill down data in full screen. 
• Is an iterative process. You can continue to drill down on values until the lowest level of data is reached. If a cell only contains a value, there's nothing to drill down into.
• Isn't limited to SUM calculations, as is the case with Drill to Transaction. 
• Can be used on data that is entered manually or via an import. Drill down takes you back to the data cells that were targeted by an import link. You can't drill down to view the raw text file that was used in the import.

Examples of how you might use Drill Down include:

• Explore the values that make up a consolidated sales figure.
• Investigate an expense line in an income statement, all the way down to the general ledger codes.
• Examine a breakdown of employees by individual cost centers to understand consolidated staff costs.

When you Drill Down on a SUM calculation, the dialog doesn't filter out values on a cell-by-cell basis to show only those values used in the calculation. You may have to search to determine which values were used. For example, you might have a SUM calculation that gives a value of 30, but the dialog shows a grid of cell values:

14 is shown even though it isn't part of the calculation. The dialog doesn't filter out the cell data to this level of detail.