Total report

Snoopyc

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!

suraj92291

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.

Snoopyc

Thank you! How to group only by sales header? Since I know how to group the fields. Please advise! Thank you!

suraj92291

Yes,you have to make group by on two fields 1st on No_Sales header and 2nd on salespersonCode_salesheader