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

Row analysis vs column analysis

(2) Share

Report

Posted on by CU13010319-0

424

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...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

KasparsSemjonovs 4,511 Super User 2025 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.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 18,797 Super User 2025 Season 2 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

Was this reply helpful? Yes No
CU13010319-0 424 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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 89,830 Super User 2025 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

Was this reply helpful? Yes No