To use Cognos product documentation, you must enable JavaScript in your browser.

Drill Down and Drill Up

You can drill down and drill up to change the focus of your analysis by moving between levels of information.

Drill down to see more detail. For example, you can drill down to the lowest-level item to examine the impact of a single aspect of your business.

Drill up to compare results. For example, you can examine revenue for a single product and then drill up to see revenue for the entire product line for comparison.

Note: When you drill back up after drilling down, you may lose filters that are applied. For example, you may create a filter to include the data for sales regions of the USA and Canada. You drill down on Florida. When you drill up again, the analysis no longer includes Canada in its scope.

To drill down or up in a single row or column, do the following:

To drill down or up in both a row and column simultaneously, do the following: