Sales Top 10 Details by Item

You access this report:

  • From the Top 10 Items in previous month metric in the Sales Dashboard: The report shows the top ten Items.

    See Sales Dashboard

  • By clicking a customer in the Sales Top 10 Details by Customer report and selecting by Product: The report displays the top ten Items bought by the selected customer.

    See Sales Top 10 Details by Customer

  • By clicking a sales representative in the Sales Top 10 Details by sales representative report and selecting by Product. The report displays the top ten Items sold by the selected sales representative.

    Sales Top 10 Details by Sales Representative.

When accessed from the metric, the report is filtered by Location by accounting entity, Customers by region, Sales reps by company, All revenue origins, and by the previous month - inherited from the metric.

When accessed from the Sales Top 10 Details by customer report, the report is filtered by Company, Sales reps by company, and by selected month.

You can apply different filters; for example, to discover the top ten Items sold in a particular region.

To change a filter, select from the Location, Customer, sales representative, Revenue Origin, and Time lists. If the lists are not displayed, click the down arrow in the report heading.

Like the Top 10 Items in previous month metric, this report displays, by default, the top ten Items in terms of Net Revenue from invoiced sales. But here you can also calculate the top ten Items in these terms:

  • Value of discounts given: Which Items were most heavily discounted. Discounts are Gross Revenue less Net Revenue.
  • Percentage of discounts given: Which Items were most heavily discounted as a percentage of Gross Revenue from sales of those Items.
  • Gross Profit.

To change the Top 10 measure, click Net Revenue, Discount, Discount in %, or Gross Profit in the column headings. Values in the selected column are sorted in descending order.

The report displays data in these columns:

Product

This column displays each of the top ten Items according to the currently selected measure.

Click a Item for these options:

  • Time Analysis: Displays the Sales Time Analysis Items Comparison report.
    Note: This report is displayed regardless of which Item is clicked.

    See Sales Time Analysis Items Comparison

  • by Customer: Displays the Sales Top 10 Details by Customer report, but filtered to display only Customers who purchased the selected Item.

    See Sales Top 10 Details by Customer

  • by sales representative: Displays the Sales Top 10 Details by sales representative report, but filtered to display only those sales representatives for the selected company.

    See Sales Top 10 Details by Sales Representative.

Revenue trend

This sparkline shows the trend of Net Revenue from invoiced sales.

Net Revenue

This column is selected by default. It displays this information:

  • Net Revenue earned from each of the top ten Items in the previous month
  • Total Net Revenue earned from the top ten Items
  • Total Net Revenue
  • Share of top ten Items: The percentage of the total Net Revenue that was earned from the top ten Items in terms of the currently selected measure.
Note: If there are fewer than ten Items, the Share of Top 10 Items is not displayed.

Discounts

Click Discounts to display the top ten Item in terms of discounts given. Discounts are Gross Revenue less Net Revenue from invoiced sales. The column displays this information:

  • Total Discount given in respect of each of the top ten Items in the previous month
  • Total of Discounts given in respect of the top ten Items
  • Total Discounts
  • Share of top ten Items: The percentage of total Discount that was given in respect of the top ten most discounted Items in terms of the currently selected measure.
Note: If there are fewer than ten Items, the Share of Top 10 Items is not displayed.

Discounts in %

Click Discounts in % to display the top ten Items in terms of discounts given as a percentage of Gross Revenue. The column displays this information:

  • Percentage Discount given in respect of each of the top ten Items in the previous month
  • Percentage of Discounts given in respect of the top ten Items
  • Percentage Discounts given in respect of all Items

Gross Profit

Click Gross Profit to display the top ten Items in terms of the gross profit generated from the Items sold. The column displays this information:

  • Gross Profit in respect of each of the top ten Items in the previous month
  • Gross Profit in respect of the top ten Items: The average of the gross profit for the top ten.
  • Gross Profit in respect of all Items.