Drill Down and Drill Up

For example, you can examine revenue for an entire product line and then drill down to see revenue for each individual product in the line. When you finish viewing individual product revenue, you can drill back up. After you familiarize yourself with the hierarchy, you can drill down and drill up multiple levels at a time. If you want to examine the impact of a single aspect of your business on the whole, you can drill down to the lowest-level category in a dimension.

The available drill-down and drill-up features depend on the display type you choose.

Drill Down

Change the category levels using one of the following:

• To drill down to a lower-level category, in the dimension line, click the lower-level category.
• To drill down one category level at a time, click a row or column heading link until you reach the category level.
• To drill down one level across all categories, right-click the column or row level selector area, and click Down a Level.
• To drill down directly to the categories associated with a specific data value in crosstab displays, double-click the data value.

Drill Up

Change the category levels using one of the following:

• In the dimension line, click the higher-level category.
• To drill up one level across all categories, right-click the column or row level selector area, and click Up a Level.
• To drill up to parent row and column categories, double-click the data value where the totals for rows and columns intersect.