Report with rows and columns variable

ignasijuan

Hello: I am working with NAV 2016 and have to make a list in which each row is a customer and the columns are the Department dimension values.
Each box should include customer sales by each Department.
Are there any examples in NAV or on YouTube where you can see how to configure a list of row and column variables?

The structure would be as follows:




Thanks a lot!

gbierkens

Why not use the Sales Analysis for this purpose:

ignasijuan

Of course!. You're right. I was obsessed with a report and had not thought about the analysis reports. Thanks a lot.

ignasijuan

It was easier than it seemed. With de Report Builder, select Matrix Wizzard. And so on ...

gbierkens

Why not use the Sales Analysis for this purpose:

ignasijuan

Of course!. You're right. I was obsessed with a report and had not thought about the analysis reports. Thanks a lot.

ignasijuan

Please, gbierkens, how do you configure the columns for Analysi Column DEP?. I can't see how define 1 column for each dimension value for Dimension DEPT.
Thanks.

ignasijuan

Look that your results are the same for each department in each row. I create a column for each Dimension Value (Department), and my results are the same. So, how tell to the system that each column should
represent the Sales Amount for one dimension value?

ignasijuan

ignasijuan

My results

gbierkens

You are right, it seems that I have made a mistake.
I was mistaken with the columns of the account schedule. It is only possible to filter the lines of a account schedule.

ignasijuan

Thus, it is not possible to obtain the report mentioned with the Sales Analysis Report tool, isn't it?

ignasijuan

It was easier than it seemed. With de Report Builder, select Matrix Wizzard. And so on ...