Order Information by Purchase Office

You access this report in one of these ways:

• By clicking the heading of the Order Information metric in Procurement dashboard and selecting by Purchase Office
• By clicking Purchase locations below 'Number of:' in the Order Information metric
• By clicking the Settings button in the table heading one of the other order information reports, selecting Select dimension, and selecting Purchase Office in the Select Dimension dialog
• By clicking a dimension element in one of the order information reports and selecting from the menu

The view of the data is filtered by these hierarchies:

• Order time
• Delivery time
• Product
• Supplier
• Ship-from
• Ship-to
• Buyer
• Order reference
• Status

To change your view of the data, select from the filter lists. If the lists are not displayed, click the down arrow in the report heading..

The Purchase Office hierarchy is selected in the heading of the data table. Each element of the hierarchy forms a row of the report.

You can select a different hierarchy, and you can expand the hierarchy and drill down to view the data at any level.

For each row the report shows this information:

• Order amount
• Number of orders
• Average order amount
• Number of order lines
• Average order line amount
• Number of Items
• Number of buyers
• Number of Purchase Offices

If you access the report from the Procurement dashboard then, by default, the complete Purchase Office hierarchy is selected. You can instead restrict the hierarchy to, for example, the top or bottom 5 Purchase Offices, measured by one of these metrics:

• Order amount
• Number of orders
• Average order amount
• Number of order lines
• Average order line amount

To restrict the hierarchy, click Complete Hierarchy and select Top Count or Bottom Count. From the Cut off list, select the number of Purchase Offices to view. From the Filter by list, select a metric.

If you enable a top count, the elements of the hierarchy are sorted in descending order, by value and the selected measures. For example, the top 5 elements by order amount displays the five elements with the highest order amount first, and the lowest order amount last. A count of the bottom 5 elements by order amount displays the element with the lowest order amount first.

If you access the report from one of the other order information reports, in which you have restricted the hierarchy, the same restriction is automatically applied. To view the complete hierarchy, select Complete Hierarchy.

To access the linked reports, click the Settings icon in the table heading, select Select dimension and select from the Select Dimension dialog. Or click an element in the table and select from the menu.