Ravindra BagaleCourses & study guides

16. Drill Up and Drill Down

By Last updated:

Manager vicharto, "Maharashtra madhe sales kiti? Aani Pune madhe? Aani Kothrud store madhe?" – hech drill down. Ya module madhe drill buttons, drill vs expand, matrix madhe +/- aani include/exclude he sagla sopya bhashet baghu.

What you will learn in this module

  • Preparing hierarchies for drilling (Date, Location, Product)
  • The four drill buttons: Drill up, Drill down (drill mode), Go to the next level, Expand all down one level
  • The difference between drilling down and expanding
  • Expand/collapse in a matrix, and Include/Exclude
  • Tips for drill-friendly reports

Concepts in this chapter

  1. 16.1Prepare the Hierarchies
  2. 16.2The Drill Buttons
  3. 16.3Drill Down vs Expand – the Difference
  4. 16.4Matrix: Expand, Collapse and +/- Icons
  5. 16.5Include and Exclude
  6. 16.6Tips for Drill-friendly Reports

The chapter recap is at the end of the last concept page.