Drilling down through data involves accessing information by starting with a general category and moving through the hierarchy allowing you to explore multidimensional data by moving from one level of detail to the next. Drill-down levels depend on the data granularity. For example, you can drill down to see sales for sales representatives by year, quarter, month, and broken down by product.
You can drill into elements of a chart to see the data in more details. As you drill up or drill down, you will see the chart change to reflect the level at which you are viewing the data. These two images come from the same dataset viewed at different levels.
To drill up or drill down
- From the Toolbox, select Workbooks, then select a workbook and worksheet.
- Select the Design workspace icon if needed.
- Right-click an element in a chart such as a bar in a graph and you will see either Drill Up or Drill Down depending on the level at which you are currently viewing the data.
- Choose Drill Down to look at more details or Drill Up to look at the data from a higher level.