You’re offline. This is a read only version of the page.
23
I'm Exported data to Excel from Analysis View but system will not creating "Pivot Table - Excel"
In Previous version which is NAV-2013 I'm able to export data with Pivot Table, But in Business Central that functionality is not working.
Can you please look into this and suggest me the solution to get Excel Pivot table from Analysis View.
is it possible to Customize this "Action" in Business Central.
Hi Akhil Donthula,
have you ever heard about the app: NCE Excel Builder?
There you are able to to create an .xls(x) file out of BC with an pivot table in it or with calculated fields also from different tables.
In NAV the tool was called NC Cube. As there is a test version available in the AppSource I would recommend you to give it a try!
BR
Max
Hi,
It's quite easy to make pivot table.
Ctrl + * //select all data for pivot
Alt -> d -> p -> Enter -> Enter -> Enter //make pivot table from selected data area
S.Kawamura
This is by design and it has been removed due to technical limitations in specific libraries.
See experience.dynamics.com/.../
No, you cannot customize the action. You might think of use PowerBI instead, as per product group reccomendation.
#1
Sohail Ahmed
1,063
#2
YUN ZHU
1,002
Super User 2025 Season 1
#3
Mansi Soni
780
Share
Report
All responses (
Answers (
