Sort and count by item sales

Business Central/NAV Developers Forum
1

Hi Everyone.,

would like to ask for an assistance. I need to create a report Sales Order by SKU - meaning I have to sort an item by the sale of the salesperson. it should count the total of each item by date,invoice no., and by customer name. It is filtered with Sales person.

What I did is I filtered it by date,Invoice no. and customer name, but the problem is I don’t know how to group it all by item.

The screenshot is in here - SKU.doc http://dynamicsuser.net/members/RubyRotairo/files/sku.docx.aspx

2

Take a look at the properties of your report data item. You’ll see several that start with the word Group. These are the ones you need to look into. As well as GroupHeader and GroupFooter sections.