What Is Drilling?

Drilling is a way to navigate through data in views quickly and easily.

• You drill down to display data in more detail, which displays more members.

  You can drill down to an actual item in the database. For example, if you work in sales, you can drill down to the city level within a sales analysis, and observe that there is a large sale pending in Paris.

• You drill up to display data in less detail, in hierarchical columns.

  For example, you might drill up from a month value to see a summary for the whole year. You can drill up in the current hierarchy, either for the entire column at the header level or for individual members. You can drill up from District to Region. Drilling up hides the current level (such as District) and retains the higher level (such as Region).