mibuso.com
Home› NAV Three Tier
Options

Report with rows and columns variable

ignasijuanignasijuan Member Posts: 21
in NAV Three Tier
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:

zctcmrtf8yzc.jpg


Thanks a lot!

Best Answers

Answers

  • Options
    ignasijuanignasijuan Member Posts: 21
    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.
  • Options
    ignasijuanignasijuan Member Posts: 21
    edited 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?


  • Options
    ignasijuanignasijuan Member Posts: 21

    0cp67mcw9mfd.jpg
  • Options
    ignasijuanignasijuan Member Posts: 21
    My results
    26q4zifqagnq.png
  • Options
    gbierkensgbierkens Member Posts: 49
    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.

    fc286fqgo0i0.png

  • Options
    ignasijuanignasijuan Member Posts: 21
    Thus, it is not possible to obtain the report mentioned with the Sales Analysis Report tool, isn't it?
Sign In or Register to comment.