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 : The report displays the top ten Items bought by the selected 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.
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.
- by Customer: Displays the Sales Top 10 Details by Customer report, but filtered to display only Customers who purchased the selected Item.
- 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.
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.
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.
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.