Report with rows and columns variable

ignasijuan · 2016-05-10

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 · 2016-05-10

Why not use the Sales Analysis for this purpose:

ignasijuan · 2016-05-10

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

ignasijuan · 2016-05-25

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

gbierkens · 2016-05-10

Why not use the Sales Analysis for this purpose:

ignasijuan · 2016-05-10

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

ignasijuan · 2016-05-10

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 · 2016-05-10

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 · 2016-05-10

ignasijuan · 2016-05-10

My results

gbierkens · 2016-05-10

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 · 2016-05-11

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

ignasijuan · 2016-05-25

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

Report with rows and columns variable

Best Answers

Answers

Categories