# Drill-Down

> Click a total to see the parts under it. Each click goes one level down.

**Field:** Data Engineering  
**Category:** Analytics & BI  
**Also known as:** Drill Down, Drilldown

## Think of it like

It is like zooming in on a map. First the country, then the city, then your street.

## Definition

Drill-down is moving from a total to the details under it. You click a number or a bar to open the next level. A year opens into quarters, then months, then days. Each step shows where the total came from. Going back up a level is called drilling up.

## Example

Lucy sees that sales fell in Q3. She clicks Q3 and sees that only September dropped. One more click shows the week.

## Why it matters

A total hides where a change came from. Drill-down finds the one part that moved, in a few clicks.

## Common mistake

Building a chart with no levels below it. Then every follow-up question goes back to the data team.

## Three principles

- **Total to detail.** Each click opens a finer level.
- **Same numbers.** The parts always add up to the total.
- **Needs levels.** Year to month, or country to store.

## Related terms

- [Dashboard](https://learn.benibix.com/term/data/dashboard)
- [Diagnostic Analytics](https://learn.benibix.com/term/data/diagnostic-analytics)
- [OLAP Cube](https://learn.benibix.com/term/data/olap-cube)
- [Pivot Table](https://learn.benibix.com/term/data/pivot-table)
- [Dimension Table](https://learn.benibix.com/term/data/dimension-table)

![Three panels joined by arrows marked click. The first shows one tall bar for the year 2026. The second splits it into four quarters, with Q3 highlighted. The third splits Q3 into July, August and September, and September is the short bar.](https://learn.benibix.com/diagrams/dat-drill-down.svg)

---

Source: https://learn.benibix.com/term/data/drill-down
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
