Exporting an analysis view in excel

(0) Share

Report

Posted on by Microsoft NAV and B...

203

Hi,

I have a customer that previously was working with NAV. He mentioned that previously when he was exporting an analysis view he was able to see it as per the screen -as a matrix rather that in a columnar form. In our version of BC you can see the matrix by exporting the analysis you get but only with a certain amount of columns . With NAV , he was seeing again only a certain amount of columns , but when he would open it in excel it gave him all the columns ( all 75) he needed.

Can someone advise how can we do that now for BC as well.

All responses (5)

Answers (1)

Verified answer

Microsoft NAV and B... 203 on at

Like (0)

Report

RE: Exporting an analysis view in excel

Thank you ZHU. This information helped. Hopefully Microsoft will get that functionality in Excel back.
Suggested answer

YUN ZHU 81,883 Super User 2025 Season 1 on at

Like (2)

Report

RE: Exporting an analysis view in excel

Hi, I think this is one place where BC is inferior to NAV.

In Nav, if you export data to Excel in Analyusis by dimensions Matrix page, you can get a pivot table.

And we can get different data in each Sheet.

This button is removed in BC, we can only export the data on the screen to Excel.

This issue is discussed in the link below.

https://experience.dynamics.com/ideas/idea/?ideaid=0b1ca999-e064-e811-bd6d-0003ff68b050

Hope this info will help.

Thanks.

ZHU
Suggested answer

MahGah 15,437 on at

Like (1)

Report

RE: Exporting an analysis view in excel

Hi

I tried the following in BC 19.4 (Docker) with Cronus data. For me my Open in Excel is matching the Matrix data. But I could be totally wrong here.

I hope some other experts provide more info here.
Microsoft NAV and B... 203 on at

Like (0)

Report

RE: Exporting an analysis view in excel

when you open in excel .

cause if you do report as excel it does not give you the matrix view that he wants.

now, the problem with open in excel is that it does not show all the columns, you generally need to open one in excel ,then, if you have a large amounts of dates or dimension values you need to click next set and do another open in excel.

is there a way of seeing the layout of the report as it is when you do show matrix but with all the data in it, when you have a lot, without having to do 3 excel files and join them in one?
Suggested answer

MahGah 15,437 on at

Like (1)

Report

RE: Exporting an analysis view in excel

Hi

Just a quick question. When you refer to open in Excel which one do you mean?

1) Open in Excel From page

2) Edit in Excel From Page

3) Save report as Excel

4) etc

Thanks