Displays sales values or quantities for 12 months
This enquiry shows a year's sales quantities and values for all items in a product group, with a column for each month, a total for the year and the monthly average. The list can be sorted by any column and exported to Excel.
Although the values are based on stock history transactions, the power of SQL server makes this enquiry quick.
