Sales Item Distribution

You access this report from the Product Distribution in previous month metric in the Sales Dashboard.

See Sales Dashboard.

By default, the report is filtered by Sales Offices by accounting entity, Customers by region, Sales reps by company, Revenue origin (Items, including 'invoice only'), and by the previous month - inherited from the metric.

You can apply different filters; for example, to display the 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.

This report displays the Item lines and Items for which there are sales figures. By default, the report displays values for Net Revenue from invoiced sales. But you can instead display the values 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.
• Average price: Which Items were sold at the greatest average price. Average price is Net Revenue from invoiced sales, divided by Units sold.

To change the measure, click Net Revenue, Discount, Discount in %, or Avg Price in the column headings.

The report displays data in these columns:

Items

The first column displays Items in respect of which there were sales. By default, the Items are grouped under the default hierarchy. To view a different part of the Item hierarchy, select from the list.

Revenue trend

This sparkline shows the trend of Net Revenue from invoiced sales over the previous 12 months.

Net Revenue

Discounts

Discounts in %

Avg Price