The 3ex.net Sales By Product Group Report is designed to help you easily identify your best selling/most popular product class over a specified period of time.
The report utilises the 3ex.net Transaction Reporting System.
The standard 3ex.net Transaction Reporting Template used for Sales By Product Group Reporting allows the end user to specify criteria including:
Once the criteria has been entered into the template, the next steps within the Sales By Product Group Reporting allows the user to review the report details on screen in a consolidated format, allowing the user to decide whether or not they need to produce a printed report. The screen shot below shows the consolidation step where the 3ex.net system displays a summary screen at Product Group level. This gives the end user a quick reference as to the Product Class, number of units sold within the class and the values of those transactions within the period reported upon.
At this point in the process the user can choose to export this information to Excel by simply right clicking on the grid.
The final step of the process allows the end user to either finish without printing or by simply ticking the check box, the standard 3ex.net Sales By Product Group Report is produced on screen.
The report displays in an Product Group consolidated format with the facility to drill down into each Product Group to reveal the linked transactions. The standard 3ex.net report displays:
As with all standard 3ex.net reports, the data displayed on screen can then subsequently be exported to csv, pdf or excel formal by simply clicking the save icon and choosing the preferred format.
Should the standard layout not meet your requirements then a Change Request can be raised to create a bespoke layout for your company needs.