Options

Total report

SnoopycSnoopyc Member Posts: 45
edited 2014-02-15 in NAV Three Tier
Hi expert, I have a sales report from sales header and sales line tables. Currently the report is grouped by the salesperson. I want to count the total sales order for each sales and then count the total sales order for the whole sales. How to accomplish this? Thank you!

Comments

  • Options
    suraj92291suraj92291 Member Posts: 49
    You have to make two group by 1st on sales header and second on salesperson.
    On 1st group by in layout use addafter total and use this expression "Count(Fields!No_SalesHeader.Value)" it's give total sales for each sales person
    On 2nd group by do same as upper it's give total sales order.
    “Any fool can know. The point is to understand.”
    ― Albert Einstein
  • Options
    SnoopycSnoopyc Member Posts: 45
    Thank you! How to group only by sales header? Since I know how to group the fields. Please advise! Thank you!
  • Options
    suraj92291suraj92291 Member Posts: 49
    Yes,you have to make group by on two fields 1st on No_Sales header and 2nd on salespersonCode_salesheader
    “Any fool can know. The point is to understand.”
    ― Albert Einstein
Sign In or Register to comment.