Creating Hierarchical Reports
Hierarchical reports allow users to navigate through multiple levels of data — from a broad overview to granular detail — within a single report.
What is a Hierarchical Report?
A report structure where data can be explored at different levels of granularity using: • Drill-down within visuals • Drill-through across pages • Bookmarks for different views • Page navigation for report sections
Designing a Multi-Level Report
Level 1: Executive Summary Page • High-level KPI cards (Total Revenue, Profit, Customer Count) • Trend line chart (monthly/yearly overview) • Top-performing categories or regions • Minimal detail, maximum impact
Level 2: Category/Department Pages • Breakdown by category, region, or department • Comparison charts (bar/column) • Tables with conditional formatting • Linked via page navigation or drill-through
Level 3: Detailed Data Pages • Individual transaction-level data • Full tables with all columns • Drill-through target pages • Export-ready views
Building the Hierarchy
Step 1: Plan Your Levels
| Level | Page | Content | Navigation |
|---|---|---|---|
| 1 | Executive Dashboard | KPIs, trends | Drill-through to Level 2 |
| 2 | Regional Analysis | Regional breakdown | Drill-through to Level 3 |
| 3 | Store Details | Individual store data | Back button to Level 2 |
Step 2: Create Pages • Create separate report pages for each level • Name pages clearly (e.g., "1. Dashboard", "2. Regions", "3. Store Detail")
Step 3: Add Drill-Through • On detail pages, add drill-through filter fields • Ensure back buttons are present on all detail pages
Step 4: Add Navigation Buttons • Use page navigation buttons for easy movement between sections • Create a consistent navigation bar across all pages
Step 5: Use Bookmarks for Views • Create bookmarks for different states/views on the same page • Toggle visibility of visuals using bookmarks • Link bookmarks to buttons for a tab-like experience
Creating Page Tabs (Tab Navigation)
Simulate tab navigation using bookmarks and buttons:
- Create all visuals for each "tab" on the same page
- Create a bookmark for each tab view (showing/hiding relevant visuals)
- Add buttons styled as tabs at the top of the page
- Assign each button's action to its corresponding bookmark
- Users click tabs to switch views
Best Practices for Hierarchical Reports
• Start broad, go deep — summary first, details on demand • Consistent layout — same header, navigation, and color scheme across pages • Clear navigation — always provide a way back to the summary • Limit pages — 5-8 pages maximum for a focused report • Use tooltips — provide context without requiring navigation • Test user flow — ensure the navigation path is intuitive • Mobile-friendly — design with mobile layout for on-the-go access