Performing a Top N/Bottom N Analysis (Product Sales)

The Top N/Bottom N window allows you to analyze the best and worst selling products in your inventory.  You can also use the Top N/Bottom N window to determine the clients that spend the most/least on products and the employees that sell the most/least products.

1. Select Inventory > Top N/Bottom N.

The Top N/Bottom N window displays.

2. Select one of the following options:

• Top N (most sold) = Select to view the best products/clients/employees.

• Bottom N (least sold) = Select to view the worst products/clients/employees.

3. Complete the following:

1. In the Distributor field, select a distributor for which to view data or leave the field blank to view data for all distributors.

2. In the Manufacturer field, select a manufacturer for which to view data or leave the field blank to view data for all manufacturers.

3. In the Class field, select a product class for which to view data or leave the field blank to view data for all product classes.

4. Select one of the following options to determine the number of results to display:

• Specific Number = Enter the number to display in the Show Top field (e.g. Top 10 or Top 25).

• Specific Percentage = Select % and enter the percentage to display in the Show Top field (e.g. Top 10% or Top 25%).

5. Select one of the following options:

• Products = Select to display data on the best-selling/worst-selling products.

• Clients = Select to display data on the clients who purchased the most/least products.

• Employees = Select to display data on the employees who sold the most/least products.

6. In the Based on Sales Between fields, select the date range for which to view data.
7. Select one of the following options:

• Base Sales on Quantity Sold = Select to sort the data by the number of products sold.

• Base Sales on Amount Sold = Select to sort the data by the sales revenue generated.

8. Click Show.

The rankings display on the right side of the window.

9. Complete the following as necessary:

• View more products/clients/employees in the rankings

  1. Change the entry in the Show Top field.

  2. Click Show.

   

• View a graph of the rankings

  1. Click Graph.

  A bar chart of the sales data displays.

  2. Complete the following as necessary:

  • View a legend for the graph = Select Show Legend.

  • View a different type of graph = Select a graph in the Graph Format field at the top of the window.

   

• Print the rankings

  1. Click Print.

  A print preview displays.

  2. Click the Print button on the toolbar.

  The Print window displays.

  3. Select a printer.

  4. Click Print.

   

• Export the rankings as a Microsoft Excel spreadsheet

  1. Click .

  The Export Format window displays.

  2. Select Excel.

  3. In the Folder field, specify the location where you want to save the spreadsheet.

  4. In the Filename field, enter a name for the spreadsheet.

  5. Click Ok.

   

related links

Viewing Average Markup & Sales History

Viewing Product Pricing History

Viewing Product Sales History