News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Analysis View by Dimen...

Small and medium business | Business Central, N...

Suggested answer

Analysis View by Dimensions

(1) Share

Report

Report

Posted on by Abhishek_P

Hello Community,

We have prepared report on Analysis view by dimensions and we have set dimensions as Column.

while extracting report to excel it shows first 32 columns of dimensions and for more dimension columns we need to re-export report after clicking next set.

Is there any other way around to extract more than 32 columns at once in excel.

Thank you !

Categories:

Dynamics 365 Business Central

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

Analysis View by Dimensions

Unfortunately, not as far as I know. . . . Open in Excel only exports what is displayed on the page.

As for the number of columns displayed, this requires a Microsoft update.

For example, https://learn.microsoft.com/en-us/dynamics365-release-plan/2022wave1/smb/dynamics365-business-central/new-capabilities-financial-reporting-account-schedules

Hope this helps.

Thanks.

ZHU

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans