The Analysis Tab in Business Central — Instant Data Analysis Without Leaving the Page
There is a moment every Business Central user knows well. You are on the Customer List, or the Item Ledger Entries, or the Posted Sales Invoices — and you need to slice the data. Group it by something. Sum a column. Filter to a subset and see a total. The old answer was to export to Excel. The new answer is the Analysis Tab.
Introduced in Business Central 2023 Wave 1 and progressively enhanced since, the Analysis Tab transforms any list page into an ad-hoc pivot and analysis tool — without leaving BC, without writing a report, and without touching Excel. This post explains what it is, how it works, and how to get the most out of it in your day-to-day work.
What Is the Analysis Tab?
The Analysis Tab is a built-in analysis mode available on most list pages in Business Central. It lets you:
- Group rows by one or more field values (e.g. group sales by customer, by posting date, by salesperson)
- Pivot columns to create a matrix view (e.g. show months across the top, customers down the side)
- Summarise numeric fields with totals, counts, averages, min, and max
- Filter the dataset to a specific subset before analysing
- Save named analysis views that can be recalled later
It sits directly on the list page as a tab — alongside the standard list view — so switching between raw data and analysis is instant. No new window, no report request page, no waiting.
How to Access It
On any supported list page, look for the Analyse button in the action bar at the top of the page. Clicking it switches the page into Analysis Mode and opens the Analysis Tab panel.
Alternatively, some pages surface the Analysis Tab directly as a named tab alongside the list — depending on whether saved analyses have already been created for that page.
Once in Analysis Mode, the page layout changes: the standard list becomes your data source, and a configuration panel appears where you define your rows, columns, and values.
The Three Building Blocks
Every analysis in the Analysis Tab is built from three components:
1. Row Groups
Row Groups define what appears down the left side of your analysis — the dimension you are grouping by. For example:
- Group by Customer Name to see one row per customer
- Group by Item No. to see one row per item
- Group by Posting Date (with date grouping set to Month) to see one row per month
You can stack multiple row groups to create nested groupings — for example, Customer Name within Salesperson Code — giving you a hierarchical breakdown.
2. Column Groups
Column Groups define what appears across the top — turning a field into column headers. This is what creates the pivot effect. For example:
- Pivot by Document Type to see separate columns for invoices, credit memos, and payments side by side
- Pivot by Month to see monthly columns across a year
Column Groups are optional. Without them, you get a flat grouped list. With them, you get a matrix.
3. Values
Values are the numeric fields you want to summarise in each cell — Amount, Quantity, Cost, and so on. For each value field, you choose the aggregation method: Sum, Count, Average, Min, or Max.
This combination of Row Groups, Column Groups, and Values covers the vast majority of ad-hoc analysis needs without any additional configuration.
Saving and Sharing Analysis Views
Once you have configured an analysis that is useful, you can save it as a named view. Saved analyses appear as tabs on the page — so returning to a frequently used breakdown is a single click.
Examples of analyses worth saving:
- Sales by Customer by Month — on Posted Sales Invoices, grouped by customer, pivoted by month, summing Amount
- Stock by Location — on Item Ledger Entries, grouped by item and location, summing Quantity
- Outstanding Payables by Vendor — on Vendor Ledger Entries, filtered to open entries, grouped by vendor, summing Remaining Amount
- Sales by Salesperson — on Customer Ledger Entries, grouped by Salesperson Code, summing Amount
Saved analyses are per-user by default. In some configurations they can be shared across users, making them useful for standardising how a team views a particular dataset.
Practical Use Cases
Month-end sales review without a report Open Posted Sales Invoices, enter Analysis Mode, group by Customer, pivot by Month, sum Amount. You have a customer-by-month revenue matrix in under a minute — no report, no Excel.
Inventory analysis by location Open Item Ledger Entries, filter to a date range, group by Item No. and Location Code, sum Quantity. Instant stock movement breakdown by location.
Aged payables snapshot Open Vendor Ledger Entries, filter to Open entries, group by Vendor Name, sum Remaining Amount. Add a column group by Due Date range for a basic ageing view.
Salesperson performance Open Customer Ledger Entries or Posted Sales Invoices, group by Salesperson Code, sum Amount. Add a date filter for the current period for an instant performance snapshot.
Identifying top items by revenue Open Posted Sales Invoice Lines (if available on your version), group by Item No. and Description, sum Amount, sort descending. Your top revenue items without a single report.
How It Compares to Other Analysis Tools in BC
Business Central offers several ways to analyse data, and it helps to understand where the Analysis Tab fits:
Analysis Tab — ad-hoc, in-page, no setup required. Best for quick exploratory analysis and recurring views on standard list pages.
Account Schedules / Financial Reports — structured financial statements (P&L, Balance Sheet). Best for formal financial reporting with defined row and column layouts.
Power BI — rich visualisation and cross-entity reporting connected to BC data. Best for dashboards, trend analysis, and sharing insights with non-BC users.
Analysis by Dimensions — the legacy dimension-based analysis tool in BC. Still available and useful for G/L-level dimensional analysis, but less flexible than the Analysis Tab for non-G/L data.
Excel Export — full data export for complex manipulation. Still the right tool when you need formulas, formatting, or analysis that goes beyond what the Analysis Tab supports.
The Analysis Tab does not replace any of these — it fills the gap between “I just want to quickly group and sum this list” and “I need to build a full report.” That gap was previously filled entirely by Excel exports, and the Analysis Tab covers most of it natively.
Limitations to Be Aware Of
Not all list pages support it. The Analysis Tab is available on most standard BC list pages, but not every page. If the Analyse button is not visible, that page does not support it.
It works on the current dataset. The Analysis Tab analyses whatever is loaded in the list — including any filters you have applied. This is a feature as much as a limitation, but it means very large unfiltered datasets may be slow to summarise.
It is not a substitute for financial reports. For formal P&L, Balance Sheet, or budget vs. actuals reporting, Financial Reports (formerly Account Schedules) remain the right tool. The Analysis Tab is not designed for that level of structured financial presentation.
Custom fields require AL work. If you have added custom fields to a page via an AL extension, those fields may not automatically appear as available dimensions in the Analysis Tab. Depending on the implementation, additional configuration may be needed.
Saved analyses are not version-controlled. If a user modifies a saved analysis, the previous version is gone. For critical reporting views, document the configuration externally as a backup.
Tips for Getting the Most Out of It
1. Start with a filter, then analyse Apply page filters to narrow the dataset before entering Analysis Mode. Analysing a filtered subset is faster and more focused than analysing the full table.
2. Use date grouping When grouping by a date field, BC lets you choose the grouping interval: Day, Week, Month, Quarter, Year. Monthly grouping is the most useful for most financial and operational analysis.
3. Save your most-used views immediately If you build an analysis that you will use again, save it before closing. Rebuilding from scratch each time wastes the efficiency gain the feature provides.
4. Use it in client demonstrations The Analysis Tab is visually impressive and immediately intuitive to business users. Showing it during a BC demo — particularly to users who are used to exporting everything to Excel — is a strong selling point.
5. Include it in end-user training Like Search In Company Data, the Analysis Tab is a high-value feature that many users discover by accident months after go-live. Building a 10-minute module into your end-user training programme pays for itself quickly.
6. Combine with FlowFields for richer analysis Pages that include FlowFields (calculated fields like Balance, Amount to Invoice, Quantity on Hand) make particularly powerful analysis sources, since those fields summarise related data and can be used as value columns in the Analysis Tab.
Summary
The Analysis Tab is one of the most significant usability improvements Business Central has received in recent years. It closes the gap between raw list data and meaningful insight — without reports, without Excel, and without leaving the page.
For consultants, it is a feature worth demonstrating prominently during implementations and showcasing in training. For end users, it is the answer to most “can I just quickly see the total by…” questions that previously required a developer or a report request.
If your users are still exporting to Excel every time they need to group or sum a list, show them the Analysis Tab. The reaction is usually immediate.
Written for Microsoft Dynamics 365 Business Central consultants and implementers. Want to get more from your Business Central environment? Get in touch with Navseal.
