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.

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

MahGah 15,529 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Microsoft NAV and B... 203 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (2)

Report

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

Was this reply helpful? Yes No
Verified answer

Microsoft NAV and B... 203 on at

Like (0)

Report

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

Was this reply helpful? Yes No