The latest version of Microsoft Dynamics 365 Business Central v22 onwards allows users to analyse data from list pages directly within BC without having to use Open in Excel or Export to Excel options to create a pivot table.

Analysis mode allows you to see the list data in different ways.  Where you might have previously filtered data using the filter pane, analysis mode gives you the ability to save multiple tabs that represent different views of the data. 

Analysis mode is  (as of November 2023) available on all screens.

To analyse data using this new feature you can switch to Analyze mode. The following video will take you through how to turn on the functions and a demonstration of this exciting new feature.

Related Articles

Additional information on the Analysis Mode functionality was shared in the Business Central Update at the November EBS User Group. 

Was this article helpful?