How to Export Data to Excel in Analysis Mode in Microsoft Dynamics 365 Business Central?
You can right click on the data in Analysis Mode and go to Export and Open in Excel.