News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Analyze, group, and pi...

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

Answered

Analyze, group, and pivot data for 2 or more table at single view

(3) Share

Report

Report

Posted on by CA Ravi Karda

16

Hello Dynamics Community,

I'm currently working on analyzing data within Business Central and I'm looking to create a combined view from multiple tables to gain deeper insights. Could anyone advise on the best approach to construct such a view, leveraging data from 2 or more tables in a single view?

Additionally, what key metrics or indicators should I consider to effectively assess this relationship?

Any insights or suggestions would be greatly appreciated!

Thank you in advance.

Categories:

Business Central

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

YUN ZHU 73,565 Super User 2024 Season 2 on at

Like (1)

Report

Analyze, group, and pivot data for 2 or more table at single view

Or you can consider external tools, such as Power BI, and then display the Power BI report in BC.

For example,

https://yzhums.com/31142/

Thanks.

ZHU
Suggested answer

KasparsSemjonovs 3,926 Super User 2024 Season 2 on at

Like (1)

Report

Analyze, group, and pivot data for 2 or more table at single view

I guess You would need to create a new page, where You display the needed values from 2 or several tables in the columns. then You can use this information to perform Analysis on these entries.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans