BI Drill-Down: Summary-to-Detail Design
Drilling from summary to detail speeds up a BI dashboard. We cover design principles and what to watch when choosing the order of dimensions.

A manager first looks at a single number: this month's net sales. If it is lower than expected, the first question is 'where?' Drill-down means answering that question on the same screen, going from summary to detail step by step.
Design principles
- Summary first, detail on demand: show only a few indicators on the first screen; open the detail when the user asks.
- Totals must hold at every level: the sum of the sub-rows must equal the parent row; otherwise users stop trusting the dashboard.
- Keep filters and period: the selected period and filters must not disappear when moving from one level to another.
- Show users where they are: a breadcrumb (for example Year > Month > Product group) and a one-click way back.
- Reach the source at the bottom: the last level should go down to the document number so the figure can be verified at the source.
- Stay fast: load heavy detail only when it is asked for.
Choosing the order of dimensions
The order should follow the user's question. For sales, the natural order is often time (year, quarter, month), then product group, then product. Dimensions such as region and customer group can be offered as side paths. For each dimension ask yourself 'which decision does this breakdown change?'; if there is no answer, remove the dimension.
Common mistakes
- Averaging a ratio at lower levels: calculate the ratio at every level by summing first and dividing afterwards.
- Too many levels: after three or four levels the user gets lost.
- Using a different definition in the detail: make sure summary and detail use the same measure definition.
Where Floemdata stands
The Gold measure and dimension catalog of Floemdata Analytics offers dimensions such as year, quarter, month and date, plus product group, product code and product name; so breakdowns are possible in the data layer. In the panel, clicking a company row opens that company's reports. A general drill-down feature inside reports is not verified in this article (not verified); this article describes design principles in general.
To get started, pick the report you use most and write down 'when this number drops, which three questions do I ask first?'; the order of the breakdown comes from there. Questions: info@floemdata.com.