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

Row analysis vs column analysis

(2) Share

Report

Posted on by CU13010319-0

In the financial reports, there is row analysis vs column analysis. What is the difference? When I created an analysis view, and added it to either or both, my total values appeared to be the same in my generated report. The only thing that appeared to change for me was the filter options via the dimension filters, based on what the dimensions were set in the analysis view. How best should they be used? They didn't seem as useful as the prior version when it was just selecting one analysis view.

Categories:

Dynamics 365 Business Central

Row and column an...

All responses (4)

Answers (0)

Suggested answer

KasparsSemjonovs 4,032 Super User 2024 Season 2 on at

Like (0)

Report

Row analysis vs column analysis

Well when You create a report it gives You option to be flexible and create it as You need.
When You want to do report based on 5 GL accounts and 100 dimension values, then You want to display dimension as rows, and GL as columns, but if You want to report all GL's and department dimension, then most likely You will want to display GL's as rows and each department as column.

In the report You can select what You want to display as rows and what to display as columns.
Suggested answer

Khushbu Rajvi. 6,868 Moderator on at

Like (1)

Report

Row analysis vs column analysis

Hope this helps: https://learn.microsoft.com/en-us/dynamics365/business-central/bi-design-financial-reports

https://learn.microsoft.com/en-us/dynamics365/business-central/bi-row-definitions
CU13010319-0 55 on at

Like (0)

Report

Row analysis vs column analysis

I am running BC US version 25.1, platform 25.0. application 25.1, it does indeed show both row and column definitions , but also row analysis and column analysis beside them in the financial reports.
Suggested answer

YUN ZHU 76,182 Super User 2024 Season 2 on at

Like (0)

Report

Row analysis vs column analysis

Hi, There doesn't seem to be any Row analysis vs column analysis in the standard. If you mean Row Definition and Column Definition.

Row Definition: Contents of the row

Column Definitions: The content of the column, for example, can be defined to display 12 months.

Hope this helps.

Thanks.

ZHU