---
id: post/thinkaboutit-be/7503
type: post
title: "How Do I: Analyze List Pages and Data Using Analysis Mode in Business Central"
summary: Analysis Mode is a built-in Business Central feature that lets users interactively explore list data through grouping, aggregation, pivoting, and filtering without exporting data or creating reports. It bridges the gap between operational lists and formal reporting, replacing many traditional ad-hoc reports by keeping analysis inside the application.
tier: community
language: en
tags:
  - analysis mode
  - ad-hoc analysis
  - list pages
  - data exploration
  - aggregations
  - pivoting
  - reporting
system: reporting
review:
  state: reviewed
  by: opus
  at: "2026-10-08T01:57:16.730Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: bd384398811a06f226de4ff866f9fae94933e12482bfbeb7c6cd32223a96d74e
evidence:
  - kind: blog
    url: https://thinkaboutit.be/2026/01/how-do-i-analyze-list-pages-and-data-using-analysis-mode-in-business-central/
    title: "How Do I: Analyze List Pages and Data Using Analysis Mode in Business Central"
    date: "2026-01-22"
    commit: null
    t: null
    quote: null
  - kind: blog
    url: https://thinkaboutit.be/2026/01/how-do-i-analyze-list-pages-and-data-using-analysis-mode-in-business-central/
    title: "How Do I: Analyze List Pages and Data Using Analysis Mode in Business Central"
    date: "2026-01-22"
    commit: null
    t: null
    quote: Analysis Mode sits between operational lists and formal reporting.
  - kind: blog
    url: https://thinkaboutit.be/2026/01/how-do-i-analyze-list-pages-and-data-using-analysis-mode-in-business-central/
    title: "How Do I: Analyze List Pages and Data Using Analysis Mode in Business Central"
    date: "2026-01-22"
    commit: null
    t: null
    quote: Analysis Mode is most effective when it replaces reports that exist mainly to answer ad-hoc or exploratory questions.
links:
  learn: []
  objects:
    - object/page/25
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: "7503"
source_id: thinkaboutit-be
source_name: think about IT - Steven Renders
url: https://thinkaboutit.be/2026/01/how-do-i-analyze-list-pages-and-data-using-analysis-mode-in-business-central/
published_at: "2026-01-22T08:00:31.000Z"
author: Steven Renders
full_text: false
words: 1430
quotes:
  - text: Analysis Mode sits between operational lists and formal reporting.
    why_it_matters: Clarifies the position of Analysis Mode in the reporting ecosystem and its intended use case for exploratory analysis rather than formal outputs
  - text: Analysis Mode is most effective when it replaces reports that exist mainly to answer ad-hoc or exploratory questions.
    why_it_matters: Provides guidance on when to choose Analysis Mode over other reporting methods based on the nature of the business question
code_objects_mentioned:
  - page Customer Ledger Entries
systems:
  - reporting
  - platform
  - development
versions_mentioned:
  - 2023 release wave 2
preview:
  embeddable: true
  frame_url: https://thinkaboutit.be/2026/01/how-do-i-analyze-list-pages-and-data-using-analysis-mode-in-business-central/embed/
  image: https://i0.wp.com/thinkaboutit.be/wp-content/uploads/2026/01/Analyse_image.png?fit=1200%2C800&ssl=1
  image_alt: null
  image_w: 1200
  image_h: 800
  site_name: think about IT
  favicon: https://i0.wp.com/thinkaboutit.be/wp-content/uploads/2026/02/cropped-SiteIcon2-1.png?fit=32%2C32&ssl=1
  probed_at: "2026-10-07T11:50:58.991Z"
---

# How Do I: Analyze List Pages and Data Using Analysis Mode in Business Central

[Read the post](https://thinkaboutit.be/2026/01/how-do-i-analyze-list-pages-and-data-using-analysis-mode-in-business-central/) · think about IT - Steven Renders (Steven Renders) · 2026-01-22 · 1430 words · tier community · reviewed (checked by Opus)

> Analysis Mode is a built-in Business Central feature that lets users interactively explore list data through grouping, aggregation, pivoting, and filtering without exporting data or creating reports. It bridges the gap between operational lists and formal reporting, replacing many traditional ad-hoc reports by keeping analysis inside the application.

## Key points

- Analysis Mode allows users to group, aggregate (Sum, Count, Average, Min, Max), pivot, and filter list data interactively while saving multiple analysis views
- Requires DATA ANALYSIS - EXEC permission and is generally available in 2023 release wave 2 and later
- Supports analysis on Query objects and related table fields, with automatic optimization for datasets over 100,000 rows
- Most effective for replacing reports that answer ad-hoc questions; classic reports remain better for fixed layouts and formal distribution
- Positioned between operational filtering and formal Power BI reporting as part of Business Central's analytics ecosystem

## Quotes

- "Analysis Mode sits between operational lists and formal reporting." (Clarifies the position of Analysis Mode in the reporting ecosystem and its intended use case for exploratory analysis rather than formal outputs)
- "Analysis Mode is most effective when it replaces reports that exist mainly to answer ad-hoc or exploratory questions." (Provides guidance on when to choose Analysis Mode over other reporting methods based on the nature of the business question)

## AL objects mentioned

As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.

- [page 25 "Customer Ledger Entries"](../../objects/page/25.md)

## Context

- Features: Analysis Mode, Data grouping, Aggregation functions, Pivoting, Date hierarchies, Filtering without page modification, Analysis view persistence, Related table field access
- Versions: 2023 release wave 2

Source: think about IT - Steven Renders, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.