Show TOC

Function documentationTop Spend by Selected Commodity Locate this document in the navigation structure

 

This report ranks the Top X sub-categories (where X is a number you define) by total spend, when you drill down from a parent commodity on the Top Spend by Commodity report. You can continue to drill down through the category hierarchy by choosing the Commodity name. This report also provides a count of the number of suppliers with spend in a commodity with a drill down to view the list of suppliers.

You can filter the data in this report by the following:

  • Time Period Beginning At and Time Period Ending

  • Spend Amount Type (Actual, Planned, or Forecast)

  • Number of Top-Ranked Commodities

Top Spend by Selected Commodity Chart

This report section includes a pie chart showing the distribution of spend among top-ranked commodities. You select the number of commodities to show in the filter criteria.

Top Spend by Selected Commodity Table

The report table below the chart lists commodities ranked by total spend from highest to lowest.

Field

Description

Rank

The relative position of this commodity compared to other commodities based on spend for the selected time period.

Commodity ID

The product category ID.

Commodity

The product category name. Choose this link to drill down to the next level of the category hierarchy.

Spend

The total spend for this commodity for time period and spend amount type.

% of Spend

The percentage of total spend attributable to this commodity.

% of Spend = (Spend for commodity/Total Spend for all commodities) * 100

Vendor Count

The number of suppliers that account for the spend amount. Choose the supplier count to drill down to the list of suppliers.