News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Analyze, group, and pi...

Business Central forum

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:

Reports and Business Intelligence

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

YUN ZHU 68,586 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,666 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... 290,326 Super User 2024 Season 2

#2

Martin Dráb 228,166 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans