Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Sometimes you need to analyze data in Business Central in a way that the standard reports don't support. These analyses are often called "ad-hoc." The following table provides links to articles that can help you learn how to do ad-hoc analyses.
| To | See |
|---|---|
| Analyze data on a list by sorting, searching, and filtering it. | Sorting, Searching, and Filtering and Searching and Filtering FAQ |
| Save the settings you use frequently on a list as a view | Save and personalize list views |
| View and analyze data from a page in Microsoft Excel | View and Edit in Excel |
| Analyze list data directly from a page | Analyze list data using data analysis mode |
| View and analyze data from a report dataset in Excel | Analyzing Report Data with Excel and XML |
Ad-hoc data analysis by functional area
The general content about ad-hoc data analysis is also available in special versions for many of the functional areas in Business Central.
| If you work with... | See |
|---|---|
| Finance | Ad-hoc analysis on finance data |
| Fixed Assets | Ad-hoc analysis of fixed assets data |
| Sustainability | Ad-hoc analysis of sustainability data |
| Sales | Ad-hoc analysis of sales data |
| Purchasing | Ad-hoc analysis of purchasing data |
| Inventory | Ad-hoc analysis of inventory data |
| Auditing | Ad-hoc analysis of change log data Analyze user status by license type |