Business Central analysis mode on list pages for quick retail questions

Analytics · 8 min read

“Which location took the most returns last month?” “What went out of the warehouse this week, by item?” Questions like these used to mean an export, a spreadsheet, and a stale answer. Analysis mode answers them on the list page itself — grouping, subtotaling, and pivoting posted data without running a report or opening another application. This guide runs two complete retail examples and then draws the line where analysis mode stops and Excel or Power BI should take over.

What analysis mode actually is (and what it does not change)

The data analysis feature lets a user analyze data directly from a list page or a query, in an interactive way: calculate, summarize, and examine, using multiple tabs that each represent a task or a view on the same data. Microsoft positions it for quick fact checking and ad-hoc analysis — when a report should not be run, when no report exists for the specific need, or when the point is to iterate quickly toward an overview.

Two properties make it safe to experiment with. Analysis mode does not change the underlying data of the list page or query, and it does not change the layout of the page when it is not in analysis mode. Closing it leaves the operational list exactly as it was. The data shown is controlled by the filters or views set on the list page, so a date or location filter applied before entering analysis mode carries in as the starting scope.

Availability: the feature was in public preview in 2023 release wave 1 for list pages and generally available in 2023 release wave 2 for list pages and queries.

Before starting: permissions and pages that say no

• Permission first. In version 23 and later, an account must be assigned the DATA ANALYSIS - EXEC permission set, or include execute permission on system object 9640 — Allow Data Analysis mode. An administrator can also deliberately exclude those permissions, so a missing toggle is a permissions conversation, not a bug report.
• Not every list offers it. Some list pages do not offer the Enter analysis mode toggle, because developers can disable analysis mode on a specific page (the AnalysisModeEnabled property in AL). If a retail add-on page has no toggle, work from the underlying standard entries page instead.
• Pre-filter big lists. The list page's filters control what analysis mode starts with. On a ledger with years of entries, set the period first — it keeps the analysis responsive and the answer scoped to the question actually asked.

Procedure 1: posted sales by period, without exporting

Question: how much was invoiced, period by period? Microsoft names Posted Sales Invoices among the list pages for ad-hoc analysis of sales, alongside Sales Orders, Customer Ledger Entries, Item Ledger Entries, General Ledger Entries, and Sales Return Orders.

1. Open the Posted Sales Invoices list and set a sensible date filter on the list first — the analysis inherits it.
2. Choose Enter analysis mode in the action bar. The page switches to the analysis layout: data area in the middle, Columns and Analysis Filters panes on the side, tabs across the top.
3. In the Columns pane, clear the columns that are not part of the answer. A lean column set is what makes the subtotals readable.
4. Drag a grouping field — for example the location or customer field available on the list — into Row Groups. Row Groups groups and sums data by one or more fields, and accepts only non-numeric fields such as text and date.
5. Drag the invoice amount field into Values. Values accepts only fields whose numbers can be added together, and the sum then appears as a subtotal for each row group instead of only as a total in the last row.
6. Turn on the Pivot Mode toggle in the Columns pane. The Column Labels area appears. Drag the generated Posting Date Month field into Column Labels: fields added there show as columns in the data area, one column per month.
7. Rename the tab to something a colleague would understand — the analysis tabs added remain in place until deleted, and return exactly as left.

What success looks like: one row per group, one column per month, a subtotal in every cell where the two cross — and the grand total still matches the filtered list's total before analysis mode. If it does not, a filter differs between the two views; find that before quoting either number.

The period columns deserve one note: date fields in analysis mode are generated as a Year–Quarter–Month hierarchy of three separate fields, based on the normal calendar — not on any fiscal calendar defined in Business Central. A retailer on a 4-4-5 fiscal calendar should therefore read month columns as calendar months, and treat fiscal-period questions as a graduation case (below). The hierarchy also applies only to date fields, not datetime fields.

Procedure 2: item ledger entries — movements in and out by month

Question: what moved, where, and when? Item Ledger Entries is a named list for ad-hoc sales analysis in Microsoft's sales guidance, and Microsoft's inventory scenarios for analysis mode include returned goods by quarter and item, movements between locations, and input and output by month.

1. Open Item Ledger Entries and pre-filter to the period under review.
2. Choose Enter analysis mode.
3. Drag the item field (and then the location field, if the question is per-store) into Row Groups, in that order — grouping levels follow the order fields are placed.
4. Drag the quantity field into Values so each group shows a summed quantity rather than a pile of individual movements.
5. Use the Analysis Filters pane to limit the entry type — for example to sale entries only for an “what went out” view, or to return-related entries for a returns view. Filters set here apply only to the current analysis tab.
6. Duplicate the tab, change only the entry-type filter on the copy, and rename both tabs. Tabs can be added, renamed, duplicated, and deleted independently, and each tab's configuration is manipulated independently of the others.
7. Optionally turn on Pivot Mode and put Posting Date Month (or Quarter, for the returns-by-quarter scenario) into Column Labels.

What success looks like: two tabs that differ by exactly one filter — movements out versus movements back — with identical grouping, so the two totals can be compared without wondering whether the definitions moved as well.

Tabs and per-tab filters: iterate without breaking the first answer

The per-tab design is the feature's quiet strength. Additional analysis filters apply only to the current tab, which means an experimental cut — one location, one month, one entry type — never disturbs the tab that already holds a trusted answer. Copying a tab is the documented way to create variations of the same analysis while experimenting.

Know the boundary, though: tabs a user sets up are only visible to that user. An analysis can be shared by copying a link to the tab, and recipients who open it are prompted to name the new tab created for them — but that is hand-to-hand sharing of a starting point, not a published report everyone opens to the same governed numbers. When a question becomes “the whole management team reviews this every Monday,” it has outgrown analysis mode (see the framework below).

Reading the summary bar and checking the answer

The summary bar along the bottom of the data area is the built-in fact check. It displays Rows, Total rows, and Filtered, plus Average, Count, Min, Max, and Sum for selected summable fields. Three quick habits make an analysis trustworthy:

• Filtered versus Total rows: if Filtered is far smaller than expected, a list filter or an analysis filter is cutting data the question meant to include.
• Mark cells before believing them: selecting rows in a summable column updates the bar's Sum and Count, so a subtotal can be spot-checked against the entries that compose it.
• Mind large ledgers: for datasets over 100,000 rows, Microsoft suggests an analysis mode optimized for large datasets. In that mode, formatting of currency, decimal, date, and timezone fields might change, and any field put into Column Labels must have a low number of distinct values — a month field qualifies; an item number field does not.

Disclaimer: analysis mode totals are operational answers read from posted entries. Figures used for financial reporting, tax, or external commitments should be reconciled to the general ledger and reviewed through the normal finance process first.

Graduate or stay: analysis mode vs Excel vs Power BI

Microsoft's own framing supports the first graduation step: for ad-hoc analysis it names exactly two features — data analysis on ledger list pages, and Open in Excel, which opens a filtered list in Excel for tools such as Analyze Data, What-If Analysis, and Forecast Sheet (opening in the browser if OneDrive is configured for system features). Analysis mode and Excel are not rivals; analysis mode is where the question gets understood, and Excel is where it goes when it needs a file, a formula, or a forecast. For a standing, multi-source retail view, the destination is Power BI — see Power BI for Business Central retail data for how that layer is set up.

FAQ

The Enter analysis mode button is missing. Why? Check permissions first: version 23 and later requires the DATA ANALYSIS - EXEC permission set or execute permission on system object 9640. Some pages also have analysis mode disabled by design.

Does analysis mode change any data? No. It does not change the underlying data of the list or query, nor the page layout outside analysis mode.

Why do the month columns ignore the fiscal calendar? Date hierarchies are generated from the normal calendar, not from fiscal calendars defined in Business Central — plan fiscal-period analysis in Excel or Power BI instead.

Can a tab be sent to a colleague? A link to a tab can be copied and shared; the recipient names the new tab created on their side. Tabs themselves remain visible only to the user who created them.