web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Exporting to excel fro...
Small and medium business | Business Central, N...
Suggested Answer

Exporting to excel from Analysis View not creating Pivot Table

(0) ShareShare
ReportReport
Posted on by Akhil Donthula 31

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.

I have the same question (0)
  • Suggested answer
    THE Italian Profile Picture
    THE Italian Microsoft Employee on at

    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.

  • Suggested answer
    S.Kawamura Profile Picture
    S.Kawamura 1,532 on at

    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

  • Suggested answer
    Max_Butcher Profile Picture
    Max_Butcher 10 on at

    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!

    appsource.microsoft.com/.../PUBID.navax_consulting|AID.nce|PAPPID.efd952a8-e941-4a79-9eaa-e52d80e65c16

    BR

    Max

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,804 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,103 Super User 2026 Season 1

#3
Kamal Khakhkhar Profile Picture

Kamal Khakhkhar 695

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans